Forum Discussion
Difference between conditional column and new column
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:
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: