دعم Power BI
البحث
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...