Functions for query editor

[Anonymous]

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 editor?

Thanks,

CM

[v-jiascu-msft]

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

[v-jiascu-msft]

Hi @Anonymous,

You can find the reference articles here: https://msdn.microsoft.com/en-us/library/mt779182.aspx

Best Regards!

Dale

[MattAllington · Accepted solution]

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)