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