Forum Discussion
Difference between conditional column and new column
Hello,
as long you you are in PowerQuery you can set "conditional columns" base on the columns you have there. You have no access to functions like weeknumbers() and so fourth, but there are some transformation functions available.
If you already loaded and transformed your data and you go to the Data Model you can create New measures and new columns. Here you have all the functions available, like weeknumbers() etc.
Why its not already there in PowerQuery, what is the main difference between these two methods of adding new columns and why the functions shouldn't be already available in "conditional columns"?
My question isn't referring to the difference between columns vs. measures.
Thank you very much in advance
Best.
Hi Applicable88
When you are in Power Query Editor, you are using M language, when data is loaded in the model, you are using DAX language. That's why you are adding columns with different formulas. While you have a choice to add a column in M, then do it instead of DAX calculated column (apply to most of the cases).
In DAX, you have calculated column and measure, they are different, too, have a look at the article:
1 Reply
Hi Applicable88
When you are in Power Query Editor, you are using M language, when data is loaded in the model, you are using DAX language. That's why you are adding columns with different formulas. While you have a choice to add a column in M, then do it instead of DAX calculated column (apply to most of the cases).
In DAX, you have calculated column and measure, they are different, too, have a look at the article: