DAX Reference Cheat Sheet
Yes I got the latest August version installed...
Hi ,
In Options --> Preview Fetures , Please make select the "New from Web Experience" and restart the Power BI desktop.
Thanks
Sorna
- oscarg8 years agoFrequent Visitor
Awesome, that did the trick, thanks a lot!
- oscarg8 years agoFrequent Visitor
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!
- msornakumar7 years agoAdvocate III
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
- oscarg7 years agoFrequent Visitor
Awesome, thanks Sorna!