DAX

[jothimeena]

When to use calculated column and measure while using switch fn in DAX?

[FBergamaschi]

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

[GeraldGEmerick · Accepted solution]

@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.