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)