IF function for conditions in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to return "High" if Sales is greater than 1000, otherwise "Low".

Power BI

Result = IF(Sales > 1000, [1], "Low")

Drag options to blanks, or click blank then click option'

A"High"

B"None"

C"Low"

D"Medium"

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong text value like "Medium" instead of "High".

Forgetting to put quotes around text values.

The IF function checks if Sales is greater than 1000. If true, it returns "High"; otherwise, it returns "Low".

2fill in blank

medium

Complete the code to return "Bonus" if Profit is greater than or equal to 500, otherwise "No Bonus".

Power BI

BonusStatus = IF(Profit [1] 500, "Bonus", "No Bonus")

Drag options to blanks, or click blank then click option'

A=

B>

C>=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' or '=' which do not correctly check for greater or equal.

Using '>' which excludes equal values.

The condition checks if Profit is greater than or equal to 500 to decide the bonus status.

3fill in blank

hard

Fix the error in the code to correctly return "Pass" if Score is at least 60, otherwise "Fail".

Power BI

Result = IF(Score [1] 60, "Pass", "Fail")

Drag options to blanks, or click blank then click option'

A<=

B>=

C<

D==

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<=' or '<' which check the wrong direction.

Using '==' which checks for exact equality only.

The correct operator to check if Score is at least 60 is '>='.

4fill in blank

hard

Fill both blanks to return "Good" if Rating is greater than 3, otherwise "Bad".

Power BI

Feedback = IF(Rating [1] [2], "Good", "Bad")

Drag options to blanks, or click blank then click option'

A>

B3

C2

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' for the operator.

Using the wrong number like 2 instead of 3.

The condition checks if Rating is greater than 3 to return "Good".

5fill in blank

hard

Fill all three blanks to return "Eligible" if Age is between 18 and 65 inclusive, otherwise "Not Eligible".

Power BI

Eligibility = IF(Age [1] [2] && Age [3] 65, "Eligible", "Not Eligible")

Drag options to blanks, or click blank then click option'

A>=

B18

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' instead of '>=' or '<' instead of '<='.

Using wrong numbers or missing the logical AND operator.

The condition checks if Age is greater than or equal to 18 and less than or equal to 65.

Practice

1. What does the IF function do in Power BI?

easy

A. Checks a condition and returns one value if true, another if false

B. Calculates the sum of a column

C. Filters rows based on a condition

D. Joins two tables together

Solution

1. Step 1: Understand the purpose of IF

   The IF function evaluates a condition and chooses between two results based on whether the condition is true or false.

2. Step 2: Compare with other options

   Calculating the sum of a column, filtering rows based on a condition, and joining tables describe other functions or operations, not IF.

3. Final Answer:

   Checks a condition and returns one value if true, another if false -> Option A

4. Quick Check:

   IF function = condition check [OK]

Hint: IF returns true-result or false-result based on condition [OK]

Common Mistakes:

• Confusing IF with SUM or FILTER functions
• Thinking IF joins tables
• Assuming IF only returns true values

2. Which of the following is the correct syntax for the IF function in DAX?

easy

A. IF condition then true_result else false_result

B. IF(condition; true_result; false_result)

C. IF{condition, true_result, false_result}

D. IF(condition, true_result, false_result)

Solution

1. Step 1: Recall DAX IF syntax

   The correct syntax uses parentheses and commas: IF(condition, true_result, false_result).

2. Step 2: Identify incorrect syntax

   Using 'then else' keywords, semicolons instead of commas, or braces are invalid in standard DAX syntax.

3. Final Answer:

   IF(condition, true_result, false_result) -> Option D

4. Quick Check:

   DAX IF syntax = parentheses and commas [OK]

Hint: Use parentheses and commas for IF in DAX [OK]

Common Mistakes:

• Using semicolons instead of commas
• Writing IF like a programming language if-then-else
• Using braces {} instead of parentheses

3. Given the DAX measure:

Sales Category = IF(SUM(Sales[Amount]) > 1000, "High", "Low")

What will be the result if the total sales amount is 750?

medium

A. 750

B. "High"

C. "Low"

D. Error

Solution

1. Step 1: Evaluate the condition

   The condition checks if total sales (750) is greater than 1000. 750 > 1000 is false.

2. Step 2: Determine the IF result

   Since the condition is false, the IF function returns the false_result, which is "Low".

3. Final Answer:

   "Low" -> Option C

4. Quick Check:

   750 > 1000 is false, so result = "Low" [OK]

Hint: Check condition result true/false to pick IF output [OK]

Common Mistakes:

• Assuming 750 is greater than 1000
• Returning the numeric value instead of text
• Confusing true and false results

4. Identify the error in this DAX formula:

Discount Status = IF SUM(Sales[Amount]) > 500, "Discount", "No Discount")

medium

A. No error, formula is correct

B. Missing parentheses around the IF arguments

C. Incorrect column name Sales[Amount]

D. Using double quotes instead of single quotes

Solution

1. Step 1: Check IF function syntax

   The IF function requires parentheses enclosing all arguments: IF(condition, true_result, false_result).

2. Step 2: Identify missing parentheses

   The formula lacks opening parentheses after IF and has an extra closing parenthesis at the end.

3. Final Answer:

   Missing parentheses around the IF arguments -> Option B

4. Quick Check:

   IF syntax needs parentheses [OK]

Hint: Always wrap IF arguments in parentheses [OK]

Common Mistakes:

• Forgetting parentheses after IF
• Confusing quotes usage (double quotes are correct here)
• Assuming column name is wrong without checking

5. You want to create a new column that labels sales as "High", "Medium", or "Low" based on Sales[Amount]:
- "High" if amount > 1000
- "Medium" if amount between 500 and 1000 (inclusive)
- "Low" if amount < 500

Which DAX formula correctly uses nested IF functions to achieve this?

hard

A. Sales Level = IF(Sales[Amount] > 1000, "High", IF(Sales[Amount] >= 500 && Sales[Amount] <= 1000, "Medium", "Low"))

B. Sales Level = IF(Sales[Amount] > 1000, "High", IF(Sales[Amount] > 500 && Sales[Amount] < 1000, "Medium", "Low"))

C. Sales Level = IF(Sales[Amount] > 1000, "High", IF(Sales[Amount] >= 500 || Sales[Amount] <= 1000, "Medium", "Low"))

D. Sales Level = IF(Sales[Amount] > 1000, "High", IF(Sales[Amount] > 500 || Sales[Amount] < 1000, "Medium", "Low"))

Solution

1. Step 1: Understand the conditions

   "High" if >1000, "Medium" if between 500 and 1000 inclusive, "Low" if less than 500.

2. Step 2: Check nested IF logic and operators

   Sales Level = IF(Sales[Amount] > 1000, "High", IF(Sales[Amount] >= 500 && Sales[Amount] <= 1000, "Medium", "Low")) correctly uses AND (&&) with >= and <= for the medium range. The other options have incorrect operators or use OR (||) which breaks the logic.

3. Final Answer:

   Sales Level = IF(Sales[Amount] > 1000, "High", IF(Sales[Amount] >= 500 && Sales[Amount] <= 1000, "Medium", "Low")) -> Option A

4. Quick Check:

   Nested IF with correct AND and inclusive bounds [OK]

Hint: Use nested IF with && and inclusive operators for ranges [OK]

Common Mistakes:

• Using OR (||) instead of AND (&&) for range checks
• Not including equal signs for inclusive ranges
• Incorrect logical operators causing wrong labels