Replace values in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to replace all occurrences of "OldValue" with "NewValue" in the 'Status' column.

Power BI

Table = Table.ReplaceValue(Source, "OldValue", [1], Replacer.ReplaceText, {"Status"})

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

A"NewValue"

BNewValue

C"OldValue"

DReplacer.ReplaceValue

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting quotes around the replacement text

Using the wrong replacer function

We need to replace "OldValue" with the string "NewValue". So the replacement value must be a text string with quotes.

2fill in blank

medium

Complete the code to replace all null values in the 'Sales' column with 0.

Power BI

Table = Table.ReplaceValue(Source, null, [1], Replacer.ReplaceValue, {"Sales"})

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

Anull

B0

C"0"

DReplacer.ReplaceText

Attempts:

3 left

💡 Hint

Common Mistakes

Using "0" (text) instead of 0 (number)

Using the wrong replacer function

We replace null with the number 0, so no quotes are needed.

3fill in blank

hard

Fix the error in the code to replace "Pending" with "Completed" in the 'OrderStatus' column.

Power BI

Table = Table.ReplaceValue(Source, "Pending", [1], Replacer.ReplaceText, {"OrderStatus"})

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

ACompleted

BReplacer.ReplaceValue

C"Completed"

D"Pending"

Attempts:

3 left

💡 Hint

Common Mistakes

Using Completed without quotes

Replacing with the wrong value

The replacement value must be a text string, so it needs quotes: "Completed".

4fill in blank

hard

Fill both blanks to replace all occurrences of "Low" with "High" in the 'Priority' column using the correct replacer.

Power BI

Table = Table.ReplaceValue(Source, [1], [2], Replacer.ReplaceText, {"Priority"})

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

A"Low"

B"High"

CReplacer.ReplaceText

DReplacer.ReplaceValue

Attempts:

3 left

💡 Hint

Common Mistakes

Using Replacer.ReplaceValue instead of Replacer.ReplaceText

Forgetting quotes around text values

We replace the text "Low" with "High" using the text replacer.

5fill in blank

hard

Fill all three blanks to replace null values with "Unknown" in the 'Category' column using the correct replacer.

Power BI

Table = Table.ReplaceValue(Source, [1], [2], [3], {"Category"})

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

Anull

B"Unknown"

CReplacer.ReplaceValue

DReplacer.ReplaceText

Attempts:

3 left

💡 Hint

Common Mistakes

Using Replacer.ReplaceText instead of Replacer.ReplaceValue

Forgetting quotes around "Unknown"

We replace null with the text "Unknown" using the value replacer.