Are you getting tired of writing “if” functions? More specific, are you getting tired of writing a lot of “if” functions with different criteria? If yes, here comes an easy-to-understand and easy-to-debug method: SWITCH. SWITCH = Nested If Statements Syntax SWITCH(expression,
value1, result1,
value2, result2,
…
…
else
) expression is any DAX expression that returns…