Top "Dax" questions

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

How do we Pass the multiple selected values of a Slicer inside DAX?

Let's say I have a table like this - [Orders] Date Amount Category 12/12/2017 100 A 12/12/2017 200 B 12/12/2017 300 C 1/1/2018 400 A 1/1/2018 500 B And I …

powerbi dax
Trying to return the maximum value of a filtered date column in Power BI

I have a table within Power BI that has a date field, and a value field. I am filtering on …

filter powerbi dax slicers
Return latest value present in power BI

I am trying to create a calculated column in power BI called most recent score that gives me the most …

powerbi dax nonblank
Calculating the standard deviation from columns of values and frequencies in Power BI

I am trying to calculate the standard deviation of a set of values in PowerBI and I am stuck. There …

powerbi dax standard-deviation frequency-distribution
Show time duration as "hh:mm:ss" in PowerBI charts

I am working with PowerBI and would like to show time duration in the format "hh:mm:ss". I know …

powerbi dax powerbi-desktop
Find Max for each day in PowerBI and DAX

I am trying to find the maximum route for each day based on the count of cars in PowerBI/DAX. …

powerbi dax
Displaying nothing in card values until a single slicer selection is made

Current setup: I have a basic report with a number of charts on the page that are all controlled by …

powerbi dax powerbi-desktop
Measure that counts entries that contain a specific string

I am making a report in which I have to show the take-rates of different items. Each item exists of …

powerbi dax
Multiple Linear Regression in Power BI

Suppose I have a set of returns and I want to compute its beta values versus different market indices. Let's …

excel-formula linear-regression powerbi dax