msornakumar's avatar
msornakumar
Advocate III
8 years ago

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 ...
Technology
msornakumar's avatar
msornakumar
Advocate III
8 years ago

Thanks for the feedback. Can you please check if you have the latest version of the Power BI desktop installed in case if you are refershing from the desktop ?

 

oscarg's avatar
oscarg
Frequent Visitor
8 years ago

Yes I got the latest August version installed...

  • msornakumar's avatar
    msornakumar
    Advocate III
    8 years ago

    Hi ,

     

    In Options --> Preview Fetures , Please make select the "New from Web Experience" and restart the Power BI desktop.

     

    Thanks

     

    Sorna

    • oscarg's avatar
      oscarg
      Frequent Visitor
      8 years ago

      Awesome, that did the trick, thanks a lot!

    • oscarg's avatar
      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's avatar
        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