Bird
0
0

Which of the following is the correct syntax to remove a column named Region in Power Query M language?

easy📝 Conceptual Q3 of 15
Power BI - Power Query Editor

Which of the following is the correct syntax to remove a column named Region in Power Query M language?

ATable.RemoveColumns(Source, {"Region"})
BRemoveColumn(Source, "Region")
CDeleteColumn(Source, Region)
DTable.Delete(Source, "Region")
Step-by-Step Solution
Solution:

  1. Step 1: Identify correct Power Query function

    The function to remove columns is Table.RemoveColumns with table and list of column names.

  2. Step 2: Check syntax correctness

    Table.RemoveColumns(Source, {"Region"}) uses correct function and syntax: Table.RemoveColumns(Source, {"Region"}).

  3. Final Answer:

    Table.RemoveColumns(Source, {"Region"}) -> Option A

  4. Quick Check:

    Remove column syntax = Table.RemoveColumns(table, {"col"}) [OK]
Quick Trick: Use Table.RemoveColumns with a list of column names [OK]
Common Mistakes:
  • Using wrong function names
  • Not passing column name as list
  • Missing quotes around column name

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Basic Visualizations - Table and matrix visuals - Quiz 2easy Basic Visualizations - Table and matrix visuals - Quiz 1easy Data Cleaning with Power Query - Why clean data drives accurate reports - Quiz 15hard Formatting and Design - Report backgrounds and images - Quiz 9hard Formatting and Design - Why design improves report clarity - Quiz 7medium Getting Data - Excel data import - Quiz 5medium Getting Data - OData and REST API connections - Quiz 3easy Power BI Basics and Architecture - Power BI Desktop vs Service vs Mobile - Quiz 11easy Power Query Editor - Replace values - Quiz 2easy Power Query Editor - Applied steps and undo - Quiz 6medium