TRUE

Syntax Return Values Always TRUE. Remarks The word TRUE is also interpreted as the logical value TRUE. Example The formula returns the logical value TRUE … Read More

SWITCH

SWITCH is a DAX function that returns different results based on the value of an expression. Syntax Argument Properties Description Expression The expression to be evaluated. … Read More

NOT

NOT is a DAX function that inverts a logical value, changing FALSE to TRUE and TRUE to FALSE. Syntax Argument Properties Description Logical A value or … Read More

OR

OR is a DAX function that returns TRUE if any of the arguments are TRUE, and FALSE only if all arguments are FALSE. Syntax Argument Properties … Read More

NAMEOF

NAMEOF is a DAX function that returns the name of a specified column or measure. Syntax Argument Properties Description Value Any fully-qualified column or measure reference. … Read More

IFERROR

IFERROR is a DAX function that returns a specified value if the first expression results in an error, otherwise it returns the value of the first … Read More

IF.EAGER

IF.EAGER is a DAX function that evaluates a condition and returns one value if TRUE and another if FALSE, using an eager execution plan. Syntax Argument … Read More

IF

IF is a DAX function that checks a condition and returns one value if TRUE and another value if FALSE. Syntax Argument Properties Description LogicalTest Any … Read More

FALSE

Syntax Return Values Always FALSE. Remarks The word FALSE is also interpreted as the logical value FALSE. Example The formula returns the logical value FALSE … Read More

COALESCE

COALESCE is a DAX function that returns the first argument that does not evaluate to a blank value, or BLANK if all arguments are blank. … Read More