Column operations (rename, remove, reorder) in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

DAX Measure Result After Column Rename

You have a table named Sales with columns ProductID, Quantity, and Price. You rename the column Price to UnitPrice. Which DAX measure will correctly calculate total sales amount after this rename?

A Total Sales = SUMX(Sales, Sales[Quantity] * Sales[UnitPrice])

B Total Sales = SUMX(Sales, Sales[Quantity] * Sales[Price])

C Total Sales = SUM(Sales[Quantity] * Sales[UnitPrice])

D Total Sales = SUMX(Sales, Quantity * UnitPrice)

💡 Hint

Remember that after renaming, the old column name Price no longer exists.

Option A uses the new column name UnitPrice correctly inside SUMX. Option A uses the old name Price which no longer exists and causes an error. Option A tries to multiply columns inside SUM which is invalid. Option A omits the table name prefix, causing an error.

❓ visualization

intermediate

Best Practice for Column Reordering in a Table Visual

You want to display a table visual in Power BI showing Customer Name, Order Date, and Sales Amount. You reorder columns in the data model to Order Date, Customer Name, Sales Amount. What will be the order of columns shown in the table visual?

A Order Date, Customer Name, Sales Amount

B Order Date, Sales Amount, Customer Name

C Sales Amount, Customer Name, Order Date

D Customer Name, Order Date, Sales Amount

💡 Hint

Remember that column order in the data model does not automatically change visual column order.

Power BI visuals display columns in the order you add them to the visual, not the data model column order. So if you add Customer Name first, it appears first regardless of data model order.

❓ data_modeling

advanced

Removing Columns to Optimize Model Size

You have a large dataset with columns OrderID, CustomerID, OrderDate, TempNotes, and DiscountCode. You want to reduce model size by removing unnecessary columns. Which column should you remove if TempNotes is only used for temporary comments during data import and never in reports?

A Remove <code>TempNotes</code> column

B Remove <code>OrderID</code> column

C Remove <code>CustomerID</code> column

D Remove <code>OrderDate</code> column

💡 Hint

Think about which columns are essential for analysis and which are not.

TempNotes is only for temporary use and not needed in reports, so removing it reduces model size without losing report functionality. Other columns are likely important for analysis.

🎯 Scenario

advanced

Reordering Columns for User-Friendly Data Entry

You are designing a Power BI data entry form using Power Apps integration. The source table has columns FirstName, LastName, Email, Phone. Users want the form to show LastName first, then FirstName, then Email, and finally Phone. How do you ensure this column order in the form?

A Rename columns to include numbers to force order

B Reorder columns in the Power Apps form layout manually

C Reorder columns in the data model to the desired order

D Remove columns and add them back in desired order

💡 Hint

Think about where the form layout is controlled.

The form layout in Power Apps is controlled inside the app, so you reorder fields there manually. Changing data model column order does not affect form layout.

🔧 Formula Fix

expert

Debugging Column Rename Impact on Existing Reports

You renamed a column SalesAmount to TotalSales in your data model. After refreshing, some reports show errors. Which of the following is the most likely cause?

A The column <code>TotalSales</code> was removed instead of renamed

B The data type of <code>TotalSales</code> changed automatically causing errors

C Existing visuals and measures still reference the old column name <code>SalesAmount</code>

D The data model refresh failed due to network issues

💡 Hint

Think about what happens when you rename a column but do not update dependent objects.

Renaming a column breaks references in visuals and measures that still use the old name SalesAmount. This causes errors until those references are updated to TotalSales.

Practice

1.

What is the main purpose of renaming columns in Power BI's Power Query Editor?

easy

A. To give columns clear, meaningful names for easier understanding

B. To delete unwanted data from the table

C. To change the data type of the column

D. To create new calculated columns

Solution

1. Step 1: Understand column renaming

   Renaming columns means changing their names to something more descriptive or meaningful.

2. Step 2: Purpose of renaming

   This helps users and report viewers understand what data the column holds without confusion.

3. Final Answer:

   To give columns clear, meaningful names for easier understanding -> Option A

4. Quick Check:

   Renaming improves clarity = To give columns clear, meaningful names for easier understanding [OK]

Hint: Rename columns to clear names before loading data [OK]

Common Mistakes:

• Confusing renaming with deleting columns
• Thinking renaming changes data values
• Mixing renaming with changing data types

2.

Which of the following is the correct way to remove a column named SalesAmount in Power Query Editor?

easy

A. Rename the column to Remove

B. Double-click the SalesAmount column and type Delete

C. Drag the SalesAmount column to the end of the table

D. Right-click the SalesAmount column header and select Remove

Solution

1. Step 1: Identify how to remove columns in Power Query

   Removing a column is done by right-clicking its header and choosing the remove option.

2. Step 2: Check each option

   Only Right-click the SalesAmount column header and select Remove correctly describes this action. Double-clicking edits names, renaming doesn't remove, and dragging reorders columns.

3. Final Answer:

   Right-click the SalesAmount column header and select Remove -> Option D

4. Quick Check:

   Remove column = Right-click + Remove [OK]

Hint: Right-click column header to remove it quickly [OK]

Common Mistakes:

• Trying to delete by renaming
• Assuming double-click deletes column
• Dragging column removes it

3.

Given a table with columns Product, Sales, and Date, what will be the new column order after applying this step in Power Query Editor?

Table.ReorderColumns(Source, {"Date", "Product", "Sales"})

medium

A. ["Sales", "Date", "Product"]

B. ["Product", "Sales", "Date"]

C. ["Date", "Product", "Sales"]

D. ["Sales", "Product", "Date"]

Solution

1. Step 1: Understand Table.ReorderColumns function

   This function changes the order of columns to the list provided in the second argument.

2. Step 2: Apply the given list

   The list is ["Date", "Product", "Sales"], so the columns will be reordered exactly in that sequence.

3. Final Answer:

   ["Date", "Product", "Sales"] -> Option C

4. Quick Check:

   ReorderColumns list = new order [OK]

Hint: ReorderColumns sets columns exactly as listed [OK]

Common Mistakes:

• Assuming original order stays
• Mixing up column names order
• Ignoring the reorder list

4.

You tried to rename a column in Power Query Editor but got an error. Which of these is the most likely cause?

Table.RenameColumns(Source, {"Sales", "Revenue"})

medium

A. The source table must be empty before renaming

B. The rename list should be a list of lists like {{"Sales", "Revenue"}}

C. The new name must be numeric

D. You cannot rename columns in Power Query Editor

Solution

1. Step 1: Check syntax for Table.RenameColumns

   The function expects a list of pairs (old name, new name) inside another list, like {{"Old", "New"}}.

2. Step 2: Identify error cause

   The code uses a single pair without the outer list, causing a syntax error.

3. Final Answer:

   The rename list should be a list of lists like {{"Sales", "Revenue"}} -> Option B

4. Quick Check:

   RenameColumns needs list of lists [OK]

Hint: Use double braces {{old, new}} to rename columns [OK]

Common Mistakes:

• Using single list instead of list of lists
• Thinking renaming is not allowed
• Expecting numeric names only

5.

You have a table with columns ID, Name, Age, and Salary. You want to remove Age, rename Salary to Income, and reorder columns so Name comes first. Which sequence of Power Query steps is correct?

hard

A. Remove Age, Rename Salary to Income, Reorder columns to ["Name", "ID", "Income"]

B. Rename Salary to Income, Remove Age, Reorder columns to ["ID", "Name", "Income"]

C. Reorder columns to ["ID", "Name", "Salary", "Age"], Remove Age, Rename Salary to Income

D. Remove Name, Rename Age to Income, Reorder columns to ["ID", "Salary"]

Solution

1. Step 1: Remove the Age column

   First, remove the unwanted Age column to exclude it from the table.

2. Step 2: Rename Salary to Income

   Next, rename the Salary column to Income for clarity.

3. Step 3: Reorder columns with Name first

   Finally, reorder columns so Name is first, followed by ID and Income.

4. Final Answer:

   Remove Age, Rename Salary to Income, Reorder columns to ["Name", "ID", "Income"] -> Option A

5. Quick Check:

   Remove, Rename, Reorder in that order [OK]

Hint: Remove unwanted, rename needed, reorder last [OK]

Common Mistakes:

• Reordering before removing columns
• Renaming wrong columns
• Removing needed columns by mistake