IF DAX Function (Logical)
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.
Syntax
IF ( <LogicalTest>, <ResultIfTrue> [, <ResultIfFalse>] )
| Parameter | Attributes | Description |
|---|---|---|
| LogicalTest |
Any value or expression that can be evaluated to TRUE or FALSE. |
|
| ResultIfTrue |
The value that is returned if the logical test is TRUE. |
|
| ResultIfFalse | Optional |
The value that is returned if the logical test is FALSE. |
Return values
Scalar A single value of any type.
Either ResultIfTrue or ResultIfFalse expression result, depending on LogicalTest.
Related articles
Learn more about IF in the following articles:
-
Optimizing IF conditions by using variables
This article describes a very common optimization pattern that relies on variables to optimize conditional expressions in DAX. » Read more
Last update: Jun 3, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/if-function-dax