Support Power BI
Rechercher
Reformat FY QTR (2023-Q1) to Q1'23 using DAX
Hello, Is it possible to refomate 2023-Q1 to Q1'23 using dax? I usually do it in PQ but I am connected to a cube so I cannot. Thank you!
Re: FIlter to Last Week Only
For your Week Number Column, your formula should be Table.AddColumn(PriorStepOrTableName, "Week Number", each Date.WeekOfYear([Date], Day.Saturday), Int64.Type) That makes Saturday your fi...
Re: Identificar nuevos clientes en función del ID de cliente y la fecha
Hola @pcda, Puede crear una medida para contar el número de clientes que han comprado solo una vez en el último mes: New Customers = VAR LastMonthStart = EOMONTH(TODAY(), -1) + 1 VAR LastMo...
Re: El ID de dispositivo existe en varias cuentas
Hola @arutkowski, Para devolver instancias en las que el 'Devices_UID_Value' coincida con más de un 'file_source_name', puede usar lo siguiente: DeviceCount = COUNTROWS( FILTER( ...
Re: Filter SQL query using parameters
Thanks for the parameters (Dates) this is helpful. Does this really impact the refresh load? As that is my expectation. So if my general ledder SQL table has 1,500,000,000 rows I an...
Re: Calc cuántas veces se usa un # calculado
Hola @jtpiazzamn, Puede usar la función "Agrupar por" para lograr esto. 1. Vaya a la pestaña "Modelado" y haga clic en "Nuevo grupo". 2. En el cuadro de diálogo "Nuevo grupo", seleccione las...
Analyze in Excel to Power Pivot
In the PowerBI Service I know that you can export the data using the Analyze in Excel Option. This creates a standard pivot table. Is there any way to either have this export to Power Piv...
Re: Hello All, I need help on how to use DAX expression in Power BI Desktop
@tamerj1 Why do we have to use "MAX" to pull the data? I know I have a live connection to Power BI desktop but I thought "MAX" was used to return the largest value in a dataset. Can you please c...
Totals adding up incorrectly in measure but not in column
I have a calculated column that works fine, and ended up converting it into a measure. This is the calculated column: x-Updated Sales Switch = SWITCH ( True (),...
Re: Recursive Functions in online versions of Power Query
This appears to be mostly a visual bug, you can still invoke the function as normal. You can also wrap it in a let liquidity_date_fn = in liquidity_date_fn and just use @liq...
Calculate % Change
Hi there, Struggling with a % change calculation which seems so simple but doesnt return anything. The calculation is the current Year/Period - Previous Year/Period / Previous Year/Period Have cre...
Re: Create stacked column chart
they event dont have 100% stacked chart example
Re: Limit SAMEPERIODLASTYEAR () to current month only
Many thanks, this worked!
Re: First and Last Row
Thanks for the reply. I'll knock something up tomorrow but an example would be if I had 10 rows i would keep rows 1 and 10. If it were 27 it would be rows 1 and 27.
Re: Count Number of Days an Equipment is at a location.
I don't know if my solution is very efficient. Here's what I did in the same situation in the Power Query Editor: I made a custom column with this formula: Duration.Days([Date Finished] - [Date Star...
Re: how to filter date to N days
@amitchandak . thank you for the response, but I am not sure that is what I want. I dont want to calculate anything, i just want to get the oldest date (last update time) in a column and filter ...
Re: Contoso by SpartaBI
Incredible dash! One question: what visual did you use in The Customer Roulette?
Re: Remaining Value of running total
Hi - Yes sorry that was jsut for the example, So what I want it to do is have the invoice amount subtract from the contract amount. But I want the new value in the "amount remainging to start the nex...
YTD vs Total Normal
Comunidad tengo el siguiente problema: Usando las funciones de tiempo de DAX TOTALYTD el resultado es correcto, al comparar 2 periodos pero si a la vista le agrego AÑO y MES y se ve el detalle, cada...
Re: The table no visible columns and cannot be queried
This has been resolved on its own. The refresh kept failing so many times and suddenly it resolved on its own.
Re: Calculate the average
@Beto_Zambom is this what you want? Column = if('Table'[Part Number]="9001",AVERAGEX(FILTER('Table','Table'[Part Number]="118"),'Table'[Qty]),'Table'[Qty])
Re: Visualice los resultados de texto provenientes de la función Switch
Hola mi problema es que la medida que he creado con el fin de contar los clientes no cuenta los distintos usuarios. La tabla de datos es así ¿Cómo puedo contar distintos usuarios...
Re: Comparar dos medidas para evaluar el estado de la dimensión
Hola Comparta el enlace de descarga del archivo PBI.
Re: Correlate data
Hi @Sakhilet , I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized ex...