Top "Dax" questions

Expression language used in Microsoft Power Pivot, SQL Server Analysis Services Tabular, and Power BI for performing analytical calculations.

Visualizing last refresh date in power bi

Is it possible to add a card in power BI that shows the last time the underneath dataset has been …

data-visualization powerbi dax m
Add leading 0 (zero) to month number in power BI

I have the below DAX formula that is concatenating a month number to a year. If the month number is …

powerbi dax
Calculate Value For Dates Between

A few references: Microsoft's documentation on DATESBETWEEN. Somewhat similar question, though the answer and derivatives of the formula don't return …

dax sql-server-2012-datatools
Can I compare values in the same column in adjacent rows in PowerPivot?

I have a PowerPivot table for which I need to be able to determine how long an item was in …

dax powerpivot
how to select last day (max day) of each month using dax

I have the following table: I need to make a measure to return the values of "last day", but I …

powerbi dax
Dynamic ranking in power bi

I have a requirement wherein, I need to get Top 5 Brands based on Sales vales in a chart. The scenario …

dynamic powerbi dax ranking slicers
Average of Grouped Sum

I am looking to create a measure that takes the average of several sums, grouped by an ID. An example …

powerbi dax
Make a slicer to filter for multiple columns

Please Help, I have this table {Table1} +----+---------+---------+-------+ | ID | Member1 | Member2 | Score | +----+---------+---------+-------+ | 1 | John | …

powerbi dax