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.