Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
The Query Editor uses Power Query "M" language:
https://msdn.microsoft.com/en-us/library/mt211003.aspx
You cannot use DAX in Query Editor but can use Power Query as smoupre said to create the expected custom column.
Best Regards,
Herbert
The Query Editor uses Power Query "M" language:
https://msdn.microsoft.com/en-us/library/mt211003.aspx
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |