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.