DAX Reference Cheat Sheet
08-07-2018 17:27 PM - last edited 09-13-2018 18:33 PM
08-07-2018 05:27 PM - edited 09-13-2018 06:33 PM
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.
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.
09-06-2018 09:48 PM
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:
But rather something like DaxFunctionNameFormattedWithoutFunction:
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!
09-13-2018 06:31 PM
Have fixed this issue by having a nested try block as below
try GetDaxFunctionDetails([DaxFunctionWebPath],[DaxFunctionNameFormatted] )
try GetDaxFunctionDetails([DaxFunctionWebPath], [DaxFunctionNameFormattedWithoutDax])
otherwise GetDaxFunctionDetails([DaxFunctionWebPath], [DaxFunctionNameFormattedWithDax])