DAX Reference Cheat Sheet

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 ...

Dax Reference Cheat Sheet.pbix162 KB

Technology

msornakumar

Advocate III

8 years ago

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

Anonymous

Not applicable

7 years ago

Hi Sorna,

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

Kristian

msornakumar
Advocate III
7 years ago
Hi Kristian ,

Yes the Pbix file has the fix for the issue. Are you facing any other errors ?

Thanks

Sorna
Anonymous
Not applicable
7 years ago
Hey,
I didn't experience any issues refreshing the list on my desktop, but I noticed it didn't import all the new functions found in the list under "new DAX functions", at least combinevalues and the UTC ones. I wonder if they haven't added those to the main reference list maybe?

Kristian
msornakumar
Advocate III
7 years ago
Yes Kristian , you are correct. Those functions are not added under the main list and hence not picked up in the report.