Column operations (rename, remove, reorder) in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to rename the column 'Sales' to 'Total Sales' in Power Query.

Power BI

Table.RenameColumns(Source, [1])

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

A{{"Sales", "Sales Total"}}

B{{"Sales", "Total Sales"}}

C{{"Amount", "Total Sales"}}

D{{"Sales", "Revenue"}}

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong column names in the list.

Not using a list of lists (missing brackets).

Swapping old and new names.

In Power Query, to rename a column, you use Table.RenameColumns with a list of pairs: the old name and the new name. Here, we rename 'Sales' to 'Total Sales'.

2fill in blank

medium

Complete the code to remove the column 'Discount' from the table in Power Query.

Power BI

Table.RemoveColumns(Source, [1])

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

A{"Discounted"}

B{"discount"}

C{"Discount"}

D{"Discounts"}

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect column name or wrong case.

Not using a list (missing brackets).

The Table.RemoveColumns function removes columns by name. The column name must match exactly, including case. Here, 'Discount' is the correct column to remove.

3fill in blank

hard

Fix the error in the code to reorder columns so that 'Date' comes first in Power Query.

Power BI

Table.ReorderColumns(Source, [1])

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

A{"Date", "Sales", "Region"}

B{Date, Sales, Region}

C{"Sales", "Region", "Date"}

D{"date", "sales", "region"}

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around column names.

Incorrect order of columns.

Wrong case in column names.

The Table.ReorderColumns function requires a list of column names as text strings in the desired order. The column names must be exact and enclosed in quotes.

4fill in blank

hard

Fill both blanks to rename 'Profit' to 'Net Profit' and remove the 'Cost' column in Power Query.

Power BI

let Renamed = Table.RenameColumns(Source, [1]), Removed = Table.RemoveColumns(Renamed, [2]) in Removed

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

A{{"Profit", "Net Profit"}}

B{"Cost"}

C{"cost"}

D{{"Cost", "Expense"}}

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping rename and remove steps.

Using wrong column names or case.

Not using lists properly.

First, rename the 'Profit' column to 'Net Profit' using Table.RenameColumns. Then remove the 'Cost' column with Table.RemoveColumns. Both functions require lists with exact column names.

5fill in blank

hard

Fill all three blanks to reorder columns to ['Region', 'Date', 'Sales'], rename 'Sales' to 'Total Sales', and remove 'Discount' in Power Query.

Power BI

let Reordered = Table.ReorderColumns(Source, [1]), Renamed = Table.RenameColumns(Reordered, [2]), Removed = Table.RemoveColumns(Renamed, [3]) in Removed

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

A{"Region", "Date", "Sales"}

B{{"Sales", "Total Sales"}}

C{"Discount"}

D{"Date", "Region", "Sales"}

Attempts:

3 left

💡 Hint

Common Mistakes

Incorrect column order in reorder step.

Wrong column names or case in rename or remove steps.

Mixing up list formats.

First, reorder columns to have 'Region', 'Date', and 'Sales' in that order. Then rename 'Sales' to 'Total Sales'. Finally, remove the 'Discount' column. Each step uses the correct function with proper lists.