Top "Dax" questions

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

Issue with DATEADD function in DAX

I recently started learning DAX. I am unable to understand DATEADD function properly. The below expression is giving error. DATEADD(…

powerbi dax tabular ssas-tabular
How to calculate Percentage out of Total value in DAX (Power BI Desktop)

I have the following Slicer in Power BI Desktop, where # of Clients is calculated as Count(Distinct(Fact.EHRTransaction.ClientFK)) …

dax percentage powerbi-desktop calculation totals
Using RELATED function in DAX with USERELATIONSHIP

I am trying to pull in a field from another table in my BISM model using the "RELATED" function. Since …

business-intelligence tabular dax
Counting TRUE() and False() in Power BI Using COUNTAX and FILTER

I have a column (Column_Name) in a table (Table_Name) that contains boolean (0 | 1) values. I am trying to get …

powerbi dax powerbi-desktop
How to convert seconds into hh:mm format in Power Bi?

In Power Bi, I have a table that contains Name and TimeSpent by user in seconds. I want to convert …

date datetime powerbi dax
No QUARTER() in DAX? Really?

While building a Calendar table with PowerQuery for a PowerPivot model in Excel 2013 I use its Date.QuarterOfYear function to …

ssas business-intelligence powerbi dax ssas-tabular
How to use GROUPBY function in PowerBI?

I tried using group by DAX function in PowerBI as Measure, New Column, New Table but I get an error …

powerbi dax
Power BI convert eight digit yyyymmdd to date using DAX

I'm trying to convert eight digit yyyymmdd to date format with DAX function. column = DATE(LEFT(TABLE[COLUMN],4),MID(TABLE[…

type-conversion powerbi dax
PowerPivot DAX - Dynamic Ranking Per Group (Min Per Group)

I am searching for a method to utilize within Microsoft PowerPivot 2010 that will allow me to perform dynamic ranking that …

min powerpivot dax rank
Calculating Percent of Total in Power Pivot Model

I have created a power pivot table as shown in the picture. I want to calculate quarter over quarter sales …

excel excel-formula pivot-table powerpivot dax