How can I write an IF Statement with Multiple Conditions in Power BI?

By /

An IF statement with multiple conditions in Power BI allows you to set up logical expressions that will evaluate to either TRUE or FALSE. These conditions can be based on a combination of different data fields or variables in your dataset. The IF statement will then perform a specific action or return a specific value based on the outcome of these conditions. This allows you to create more complex and customized calculations or data transformations in your Power BI reports.

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"
)

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 .

Additional Resources

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

x

Related terms:

  1. How Do You Write a Case Statement in Power BI?
  2. How to Use If Statement with Multiple Conditions in R?
  3. How can MySQL utilize a Case Statement with Multiple Conditions?
  4. How to write a case statement in VBA?
  5. How do I write a Case Statement in Google Sheets?
  6. How to Write a Case Statement in Pandas (With Example)
  7. How do I Write a Case Statement in Excel?
  8. How to Write a Nested If Else Statement in R (With Examples)
  9. How can I create a measure in Power BI that includes multiple filter conditions?
  10. dplyr: Use mutate() with Multiple Conditions