Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Functions for query editor

Hello,   It seems that a lot of functions can't be used in the query editor. For example "YEAR" and "WEEKNUM". Please can you tell me where to find a list of functions that can be used in the query...
Need Help
  • MattAllington's avatar
    MattAllington
    8 years ago

    Create a blank query

    click the custom function step (fx button)

    type in =#shared

     

    thia will give you a list of functions.  He query edit has a completely different language (M) than power pivot (DAX)

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

 

Best Regards!
Dale