DAX functions

In this DAX functions section, we propose DAX functions scripts examples to calculate different values in SSAS Cube in tabular mode or in Power BI reports. DAX functions are also called DAX Formulas.

These DAX expressions are used in SQL Server Analysis Services (SSAS in tabular mode), Power BI Desktop, Azure Analysis Services and also in Excel PowerPivot.

Some example type of functions are for example :
– Date and time functions
– Time-intelligence functions
– Filter functions

The available articles:

How to calculate last month value in DAX for Power BI?

September 3, 2020

How to calculate the last month value in DAX for Power BI? Managers, Financial advisors and Business Consultants uses intensively month comparisons. To create these comparison measures, use the DAX time intelligence functions available in the DAX editor. Let’s use the PREVIOUSMONTH DAX function to address this. How to calculate …

How to calculate year-to-date value in DAX for Power BI?

July 23, 2020

How to calculate a year-to-date value of the sales in DAX for Power BI? Also called YTD, it represents the total to date of a given measure. For example, to calculate the year-to-date sales total with a DAX formula, use the built-in function called TOTALYTD. In this example, simply copy …

Calculate the last year value in DAX for Power BI?

October 31, 2019

With Power BI, how to calculate the last year value in DAX? Simply use the two available DAX CALCULATE function combined with the PREVIOUSYEAR function. In financial dashboard and reports, use the previous year value for comparison and variance calculation with the current year. Indeed analyzing financial figures is often about time comparison and rolling forecasts. How to calculate last year value in DAX for Power BI? First option is to …