Power BI: How to Write an IF Statement with Multiple Conditions


You can use the following syntax in DAX to write an IF statement with multiple conditions in Power BI:

Method 1: Write an IF Statement with OR Condition

Rating = 
IF(
   OR(
       'my_data'[Points] > 20,
       'my_data'[Assists] > 4
      ),
   "Good",
   "Bad"
)

This particular example creates a new column named Rating that returns “Good” if the value in the Points column is greater than 20 or the value in the Assists column is greater than 4.

If neither of these conditions are met, then the function returns “Bad” instead.

Method 2: Write an IF Statement with AND Condition

Rating = 
IF(
   AND(
       'my_data'[Points] > 20,
       'my_data'[Assists] > 4
      ),
   "Good",
   "Bad"
)

This particular example creates a new column named Rating that returns “Good” if the value in the Points column is greater than 20 and the value in the Assists column is greater than 4.

If both of these conditions are not met, then the function returns “Bad” instead.

The following examples show how to use each method in practice with the following table in Power BI named my_data:

Example 1: Write an IF Statement with OR Condition in Power BI

Suppose we would like to add a new column that contains “Good” if the value in the Points column is greater than 20 or the value in the Assists column is greater than 4.

To do so, click the New column icon:

Then type in the following formula into the formula bar:

Rating = 
IF(
   OR(
       'my_data'[Points] > 20,
       'my_data'[Assists] > 4
      ),
   "Good",
   "Bad"
)

This will create a new column named Rating that contains the value “Good” or “Bad” based on the corresponding values in the Points and Assists columns:

Example 2: Write an IF Statement with AND Condition in Power BI

Suppose we would like to add a new column that contains “Good” if the value in the Points column is greater than 20 and the value in the Assists column is greater than 4.

To do so, click the New column icon:

Then type in the following formula into the formula bar:

Rating = 
IF(
   AND(
       'my_data'[Points] > 20,
       'my_data'[Assists] > 4
      ),
   "Good",
   "Bad"
)

This will create a new column named Rating that contains the value “Good” or “Bad” based on the corresponding values in the Points and Assists columns:

Note: You can find the complete documentation for the IF function in DAX here.

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

How to Count Number of Occurrences in Power BI
How to Write an IF Statement in Power BI
How to Use “If Contains” Formula in Power BI

Leave a Reply

Your email address will not be published. Required fields are marked *