See also

For more details regarding this recipe, refer to the following links:

• IF: https://docs.microsoft.com/en-us/dax/if-function-dax

• SWITCH: https://docs.microsoft.com/en-us/dax/switch-function-dax

• Making the "Case" for SWITCH(): https://powerpivotpro.com/2012/06/dax-making-the-case-for-switch/

• DAX – the diabolical genius of "SWITCH TRUE": https://powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/

• DAX IF & Switch Statement Performance – Does Order Matter?: https://joyfulcraftsmen.com/blog/dax-if-switch-statement-performance-does-order-matter/