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

oscarg

Frequent Visitor

8 years ago

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!

msornakumar

Advocate III

7 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

oscarg
Frequent Visitor
7 years ago
Awesome, 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