Forum Discussion
DAX
When to use calculated column and measure while using switch fn in DAX?
jothimeena Many people say that you should never use a DAX calculated column but should rather create calculated columns in Power Query Editor. If you are using a SWITCH statement, I would go with a measure over a Power Query Editor custom column because Power Query does not have a switch statement equivalent but instead you would need to use nested if then else statements.
If you can provide additional information on what exactly you are trying to do then I can probably be of more help.
2 Replies
jothimeena Many people say that you should never use a DAX calculated column but should rather create calculated columns in Power Query Editor. If you are using a SWITCH statement, I would go with a measure over a Power Query Editor custom column because Power Query does not have a switch statement equivalent but instead you would need to use nested if then else statements.
If you can provide additional information on what exactly you are trying to do then I can probably be of more help.
Can you clarify what you mean?
are you asking
1) when to use SWITCH in a measure or a column?
or
2) how to choose between a column or a measure when SWITCH in involved in your code
?
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
