IF

IF Checks if a condition provided as the first argument is met. Returns one value if the condition is TRUE, and returns another value if the condition is FALSE.


Syntax

IF(logical_test,value_if_true[, value_if_false])

Parameters

Logical_test – Any value or expression that can be evaluated to TRUE or FALSE.

Value_if_true – The value that is returned if the logical test is TRUE.

Value_if_false – The value that is returned if the logical test is FALSE. If omitted, BLANK is returned.

Return Value

Any type of value that can be returned by an expression.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Logical Functions / IF