DAX syntax sugar examples

Robert-RK — Sun, 03 May 2020 18:47:43 GMT

Hi,

I just came accross article on syntax sugar in DAX - https://exceleratorbi.com.au/simple-filters-and-syntax-sugar-in-dax/

Total Sales Syntax Sugar = SUM(Sales[ExtendedAmount])

Total Sales Full Syntax = SUMX(Sales, Sales[ExtendedAmount])

Total Sales Prior Year Syntax Sugar =

CALCULATE(

[Total Sales],

SAMEPERIODLASTYEAR('Calendar'[Date])

Total Sales Prior Year Full Syntax =

CALCULATE(

[Total Sales],

DATEADD('Calendar'[Date], -1, YEAR))

Total Sales of Bikes Simple =

CALCULATE(

[Total Sales],

Product[Category] = "Bikes")

Total Sales of Bikes Full Version =

CALCULATE(

[Total Sales],

FILTER(

ALL(Product[Category]),

Product[Category] = "Bikes"))

Does anyone know other exampes of syntax sugar in DAX?

Robert

Re: DAX syntax sugar examples

Anonymous — Sun, 03 May 2020 20:35:54 GMT

Hi Robert-RK ,

https://www.sqlbi.com/articles/analyzing-distinctcount-performance-in-dax/

This is Syntax Sugar for CountRows and Distinct.

https://www.sqlbi.com/?s=syntax+sugar

Once you open any article in Chrome, just press Ctrl+F and Seach for Sugar in each articles in the link provided above and you will get many more examples.

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

topic DAX syntax sugar examples in DAX Commands and Tips

DAX syntax sugar examples

Re: DAX syntax sugar examples