Using DAX in Query Editor

[MbProg]

In Query Editor you are able to create a custom column. But I was not able to code with DAX in the Query Editor. Is it not possible?

I need to create a custom column in the Query Editor, which gets a value according to the value of another column and the current date. And I need to do that in the Query Editor, because I want to unpivot the new column after that.

How can code DAX in Query Editor?

[v-haibl-msft]

@MbProg

You cannot use DAX in Query Editor but can use Power Query as smoupre said to create the expected custom column.

Best Regards,

Herbert

[Greg_Deckler · Accepted solution]

The Query Editor uses Power Query "M" language:

https://msdn.microsoft.com/en-us/library/mt211003.aspx