cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MbProg
Helper II
Helper II

Using DAX in Query Editor

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?

1 ACCEPTED SOLUTION
Greg_Deckler
Super User IV
Super User IV

The Query Editor uses Power Query "M" language:

 

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

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
v-haibl-msft
Microsoft
Microsoft

@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
Super User IV
Super User IV

The Query Editor uses Power Query "M" language:

 

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

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors