Write Conditional Statement Using SWITCH in DAX and Power BI
radacad.com › write-conditional-statement-usingJan 21, 2020 · Write Conditional Statement Using SWITCH in DAX and Power BI. Posted on January 21, 2020. Conditional expressions are one of the most commonly used expressions in any language as well as DAX. However, in DAX, if you have multiple IF THEN expressions, there is an easier way of doing it; using a function called SWITCH, this blog is about how you can use switch function in DAX and Power BI to write a conditional expression.
SWITCH function (DAX) - DAX | Microsoft Learn
learn.microsoft.com › en-us › daxJun 21, 2022 · DAX SWITCH(<expression>, <value>, <result> [, <value>, <result>]… [, <else>]) Parameters Return value A scalar value coming from one of the result expressions, if there was a match with value, or from the else expression, if there was no match with any value. Remarks All result expressions and the else expression must be of the same data type.
SWITCH – DAX Guide
dax.guide › switchJan 18, 2023 · This article describes how to optimize DAX expressions with mutually exclusive calculations that might cause slow query performance. » Read more. Optimizing IF and SWITCH expressions using variables. This article describes how variables should be used in DAX expressions involving IF and SWITCH statements in order to improve performance. » Read more