Power BI Support

Search

Re: Get average of number of brands purchased

You're completely right, thanks for the correction! In my example the number I'd be looking for would be 2.  It sort of worked. I have 55K entries, divided in 790 unique customers and 12 brands...

Re: Filtrar la fecha por los últimos 30 días

Hola Por favor, siga las instrucciones que he mencionado en mi mensaje anterior.

Re: Scheduled Refresh based on countries

Hi @Nithiyanandam_k    if these are all in one dataset then you will have to refresh it throughout the day. If there are in different datasets then when you configure the sched...

Re: Copy latest row value in entire column

Hi, measure, not column Latest Barnd Value = Calculate (     Calculate ( max ( Table [Brand] ), Filter ( Table , Table [CreationDate] = Max ( Table [CreationD...

Re: Copiar el último valor de fila en toda la columna

Hola medida, no columna Último valor de Barnd = Calcular ( Calcular ( ..max ( Mesa [Marca] ), Filtro ( Mesa , Mesa [Fecha de creación] = Máximo ( Mesa [Fecha de cre...

4 semanas sobre 4 semanas

Hola a todos. Necesita ayuda con la última parte de una medida. Los datos con los que trabajo se agregan en un período de 4 semanas y necesito calcular 4 semanas sobre 4 semanas Creé una medida para...

Problem Calculating Date Diff from Date formatted DD/MM/YYYY HH:MM

Hi Everyone, i have a problem that i just cant seem to solve and im certain there is a simple alternative out there. I have a column (Example below) that has a cell formatted DD/MM/YYYY Hours:Minutes...

Re: Updating theme for slicer to default to dropdown

The PowerBI themes page doesn't seem to reference the slicer options. This post did provide the answer though: https://community.powerbi.com/t5/Desktop/How-to-get-the-dropdown-orientation-slicer-...

Re: transpose column multiple columns

Hi, You obtain this by applying the steps of the attached file If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution...

Re: Total acumulado por filas de conteo de fechas

No está funcionando como se esperaba. esto es lo que estoy recibiendo Al mismo tiempo que me gustaría filtrar por nombre, por ejemplo si filtro por Abel estoy obteniendo Que es lo ...

Relación desafiante entre conjuntos de datos

Hola, estoy casi seguro de que esto no es posible, pero espero que haya una solución. Tengo cuatro conjuntos de datos en dos áreas de preocupación: dos conjuntos de datos (Grados de Matemáticas y...

Show rows that are NOT in linked tables results

Hello,   I have the following example tables:   Table1- Course information CourseID1 CourseName1 CourseID2 CourseName2 CourseID3 CourseName3   Table2- Users in courses UserID...

Re: I have a requirement where I need to apply different colors to each column header in matrix

Hi Ibendin,   Can you please privide the accurate link to vote please. 

Re: Running Total by date counting rows

It is not working as expected.  this is what I am getting At the same time as I will like to filter by name, for example if I filter by Abel I am getting Which is what I am expecti...

Table and Matrix Visuals Not Appearing In Report

We are using the JavaScript Client API to embed reports. Since last week, we have been an issue where table and matrix visuals sometimes do not appear on the report (the title appears) and the Render...

Re: BUG < Calculations Failing for Published Workbooks with Mixed Storage Mode

This thread definitely seems related to this one Calculated column works in Power BI desktop but no... - Page 2 - Microsoft Power BI Community

Re: data divided by YTD, PYTD and month

@TAI This may help: Better Year to Date Total - Microsoft Power BI Community   Sorry, having trouble following, can you post sample data as text and expected output? Not really en...

Custom Theme: How to set item background and font color in slicer

With the newest desktop push, our previous .json color themes no longer work and throw many different errors.   I started with a new .pbix file, and started rebuilding the color theme from scr...

Token Entonces error esperado

Hola a todos No estoy familiarizado con el uso de Power BI y al escribir esta fórmula de consulta de energía, recibo este error "Token entonces esperado" y no estoy seguro de cómo solucionarlo. ...

Re: Events in progress with proportional count

@jori,   Try this:   _CountNew = VAR MinDate = MIN ( Datumstabelle[FullDateAlternateKey] ) VAR MaxDate = MAX ( Datumstabelle[FullDateAlternateKey] ) + TIME ( 23, 59, 59 ) VA...

Re: Filter looking at 2 measures not working.

@DataInsights  https://www.dropbox.com/s/8s2nm6w11fjnkma/TEST%20File%20Charges.pbix?dl=0   Here is a link to a sample file I prepared. Within I have a few example as well as (hopefully) ...

Gráfico de líneas y medida para la medida de cuota de mercado

¿Cómo visualizar una medida de cuota de mercado a lo largo del tiempo en el eje X en un gráfico de líneas?

Re: MINX and MAXX returning higher and lower volume not year

Thank you! This is exactly what I needed. 

Re: How to order the months to appear in the right order on a slicer dropdown?

Never mind I`ve solved it . But thanks anyway for looking and trying to help

Re: API returning only 1000 results

Thanks, I contacted SDMX, and they said there is no page 2.  The entire data WAS loading into Power BI, but I couldn't get it out into Excel.  I eventually just manually merged every Code I...