IF function for conditions in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the IF function do in Power BI?

The IF function checks a condition and returns one value if the condition is true, and another value if it is false.

beginner

Write the basic syntax of the IF function in Power BI DAX.

IF(<condition>, <value_if_true>, <value_if_false>)

intermediate

Can the IF function handle multiple conditions in Power BI?

Yes, by nesting IF functions inside each other, you can check multiple conditions step by step.

beginner

Example: What does this formula do? IF(Sales[Amount] > 1000, "High", "Low")

It checks if the sales amount is greater than 1000. If yes, it returns "High"; otherwise, it returns "Low".

beginner

Why is the IF function useful in business reports?

It helps to categorize data or create labels based on conditions, making reports easier to understand.

What will IF(5 > 3, "Yes", "No") return?

A "No"

B 3

C 5

D "Yes"

Since 5 is greater than 3, the condition is true, so IF returns "Yes".

Which part of IF function is the condition?

A The first argument

B The second argument

C The third argument

D None of the above

The first argument in IF is the condition to check.

How do you check multiple conditions with IF in Power BI?

A Use SWITCH instead

B Use only one IF function

C Use nested IF functions

D Use SUM function

You can nest IF functions inside each other to check multiple conditions.

What does IF(Sales[Amount] = 0, "No Sales", "Sales") do?

A Filters sales data

B Labels zero sales as "No Sales" and others as "Sales"

C Calculates total sales

D Returns sales amount

It checks if sales amount is zero and labels accordingly.

What is the output of IF(FALSE, 10, 20)?

A 20

B 10

C FALSE

D Error

Since the condition is false, IF returns the third argument, 20.

Explain how the IF function works in Power BI and give a simple example.

Think about checking if a number is bigger than another.

Describe how you can use multiple IF functions together to check more than one condition.

Imagine asking two questions one after another.