Applied steps and undo in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a new applied step that filters rows where Sales is greater than 1000.

Power BI

let
    Source = Excel.CurrentWorkbook(){[Name="SalesData"]}[Content],
    FilteredRows = Table.SelectRows(Source, each [Sales] [1] 1000)
in
    FilteredRows

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

A<

B=

C>

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' causes filtering of smaller values.

Using '=' filters only rows with Sales exactly 1000.

We use the greater than operator (>) to filter rows where Sales is more than 1000.

2fill in blank

medium

Complete the code to undo the last applied step by removing it from the steps list.

Power BI

let
    Source = Excel.CurrentWorkbook(){[Name="SalesData"]}[Content],
    RemovedLastStep = List.RemoveLastN(#"PreviousSteps", [1])
in
    RemovedLastStep

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

A1

B2

C0

D3

Attempts:

3 left

💡 Hint

Common Mistakes

Removing 0 steps does nothing.

Removing more than 1 step removes too many steps.

Removing 1 step undoes the last applied step.

3fill in blank

hard

Fix the error in the code that tries to rename a column but uses the wrong function.

Power BI

let
    Source = Excel.CurrentWorkbook(){[Name="SalesData"]}[Content],
    RenamedColumns = Table.[1](Source, "OldName", "NewName")
in
    RenamedColumns

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

ARenameColumns

BRenameColumn

CRenameColumnNames

DRename

Attempts:

3 left

💡 Hint

Common Mistakes

Using singular form RenameColumn causes syntax error.

Using Rename is not a valid function.

The correct function to rename columns is Table.RenameColumns.

4fill in blank

hard

Fill both blanks to add a new applied step that changes the data type of the 'Date' column to date type.

Power BI

let
    Source = Excel.CurrentWorkbook(){[Name="SalesData"]}[Content],
    ChangedType = Table.[1](Source, [2])
in
    ChangedType

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

ATransformColumnTypes

BChangeType

DRenameColumns

Attempts:

3 left

💡 Hint

Common Mistakes

Using RenameColumns instead of changing type.

Using wrong argument format for the type change.

The correct function is Table.ChangeType and the second argument is a list of column-type pairs.

5fill in blank

hard

Fill all three blanks to add a step that filters rows where 'Region' equals 'West' and then undo that step.

Power BI

let
    Source = Excel.CurrentWorkbook(){[Name="SalesData"]}[Content],
    FilteredRows = Table.SelectRows(Source, each [[1]] = [2]),
    UndoStep = List.RemoveLastN([3], 1)
in
    UndoStep

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

ARegion

B"West"

C#"FilteredRows"

D#"Source"

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong column name or missing quotes around 'West'.

Undoing the wrong step by removing 'Source' instead of 'FilteredRows'.

We filter by 'Region' column equal to 'West', then undo by removing the last step which is 'FilteredRows'.