DAX Function Guide

IF
Empty image or helper icon

Sam McKay

CEO & Founder

How does the IF work?
IF function (DAX) checks whether a condition is satisfied as the first statement. It returns one value if the condition is TRUE, and if the condition is FALSE returns another value.
IF Formula Syntax
IF(logical_test>,<value_if_true>, value_if_false) 
How do you use the IF?

The IF function attempts to return a single data type in a column. Therefore, if the values returned by value_if_true and value_if_false are of different data types, the IF function will implicitly convert data types to accommodate both values in the column. For example, the formula IF(<condition>,TRUE(),0) returns a column of ones and zeros and the results can be summed, but the formula IF(<condition>,TRUE(),FALSE()) returns only logical values.

Related Blog Posts

Loading

Considerations when using the IF?

If the value of value_if_true or value_if_false is omitted, IF treats it as an empty string value (“”).

If the value referenced in the expression is a column, IF returns the value that corresponds to the current row.

Related Video Tutorials

Loading

Formula examples using the IF
=IF([Calls]<200,"low",IF([Calls]<300,"medium","high"))
=IF([StateProvinceCode]= "CA" && ([MaritalStatus] = "M" || [NumberChildrenAtHome] >1),[City])
Related Courses

Loading