DAX Reference Cheat Sheet

Regular Visitor
4828 Views
Regular Visitor
Posts: 26
Registered: ‎05-18-2016

DAX Reference Cheat Sheet

[ Edited ]

This Power BI report provides the DAX reference \ Cheat sheet. This report extracts the data from the Dax references from the below MSDN link. The Web Data source and Add tables using using Examples has been used to create the report.

 

https://msdn.microsoft.com/en-us/query-bi/dax/dax-function-reference

 

Hope this report provides a comprehensive view of all the available DAX functions. The cool part is when refreshed it will bring the newly added DAX functions as well in future.

 

 

Attachment
Frequent Visitor
Posts: 6
Registered: ‎03-19-2018

Re: DAX Reference Cheat Sheet

This is awesome, the refresh isnt working btw...Smiley Frustrated

Regular Visitor
Posts: 26
Registered: ‎05-18-2016

Re: DAX Reference Cheat Sheet

Thanks for the feedback. Can you please check if you have the latest version of the Power BI desktop installed in case if you are refershing from the desktop ?

 

Frequent Visitor
Posts: 6
Registered: ‎03-19-2018

Re: DAX Reference Cheat Sheet

Yes I got the latest August version installed...

Regular Visitor
Posts: 26
Registered: ‎05-18-2016

Re: DAX Reference Cheat Sheet

Hi ,

 

In Options --> Preview Fetures , Please make select the "New from Web Experience" and restart the Power BI desktop.

 

Thanks

 

Sorna

Frequent Visitor
Posts: 6
Registered: ‎03-19-2018

Re: DAX Reference Cheat Sheet

Awesome, that did the trick, thanks a lot!

Frequent Visitor
Posts: 6
Registered: ‎03-19-2018

Re: DAX Reference Cheat Sheet

Hi Sorna,

 

Once again I tried to update the file to include the new DAX formulas that were just released and I got the attached error. I think the problem is that the the URL for this new functions is as follows: https://msdn.microsoft.com/en-us/query-bi/dax/norm-dist-dax

 

So it includes the standard DaxFunctionWebPath but the DaxFunctionName is not DaxFunctionNameFormatted: 

norm-dist-function-dax

Neither DaxFunctionNameFormattedWithoutDax:

norm-dist-function

 

But rather something like DaxFunctionNameFormattedWithoutFunction:

norm-dist-dax

 

 

So how can we change the function GetDaxFunctionDetails to accomodate three possible scenarios using:

DaxFunctionNameFormatted, DaxFunctionNameFormattedWithoutDax or DaxFunctionNameFormattedWithoutFunction

 

 

= try GetDaxFunctionDetails([DaxFunctionWebPath],[DaxFunctionNameFormatted] ) otherwise GetDaxFunctionDetails([DaxFunctionWebPath], [DaxFunctionNameFormattedWithoutDax])

 

Any help would be greatly appreciated, thanks!

Regular Visitor
Posts: 26
Registered: ‎05-18-2016

Re: DAX Reference Cheat Sheet

Hi ,

 

  Have fixed this issue by having a nested try block as below

 

try GetDaxFunctionDetails([DaxFunctionWebPath],[DaxFunctionNameFormatted] )
otherwise
try GetDaxFunctionDetails([DaxFunctionWebPath], [DaxFunctionNameFormattedWithoutDax])
otherwise GetDaxFunctionDetails([DaxFunctionWebPath], [DaxFunctionNameFormattedWithDax])

 

Thanks

 

Sorna

Frequent Visitor
Posts: 6
Registered: ‎03-19-2018

Re: DAX Reference Cheat Sheet

Awesome, thanks Sorna!

Regular Visitor
Posts: 22
Registered: ‎12-07-2017

Re: DAX Reference Cheat Sheet

Hi Sorna,

Was wondering if the pbix file you uploaded has this fix included or not?

Kristian