topic Re: DAX in DAX Commands and Tips

DAX

jothimeena — Tue, 02 Sep 2025 20:35:35 GMT

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

Re: DAX

GeraldGEmerick — Tue, 02 Sep 2025 20:52:12 GMT

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.

Re: DAX

FBergamaschi — Wed, 03 Sep 2025 09:50:05 GMT

Can you clarify what you mean?

are you asking

1) when to use SWITCH in a measure or a column?

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