Bird
0
0

Identify the error in this Power Query step:

medium📝 Formula Fix Q6 of 15
Power BI - Power Query Editor
Identify the error in this Power Query step:
Table.TransformColumnTypes(Source, {"Sales", type number})
AIncorrect function name used
BMissing double braces around the column-type pair
CWrong data type specified
DSource table is not defined
Step-by-Step Solution
Solution:

  1. Step 1: Review correct syntax for Table.TransformColumnTypes

    The second argument must be a list of lists: {{"ColumnName", type}}.

  2. Step 2: Check given code

    It uses single braces {"Sales", type number} instead of double braces, causing syntax error.

  3. Final Answer:

    Missing double braces around the column-type pair -> Option B

  4. Quick Check:

    Correct syntax requires double braces [OK]
Quick Trick: Use double braces for column-type pairs [OK]
Common Mistakes:
  • Using single braces instead of double
  • Misspelling function names
  • Assuming data type is wrong without checking syntax

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 14medium Basic Visualizations - Card and multi-row card - Quiz 14medium Basic Visualizations - Why choosing the right visual matters - Quiz 8hard Data Cleaning with Power Query - Pivoting columns - Quiz 10hard Formatting and Design - Visual formatting options - Quiz 2easy Formatting and Design - Visual formatting options - Quiz 13medium Getting Data - Excel data import - Quiz 11easy Power Query Editor - Column operations (rename, remove, reorder) - Quiz 11easy Power Query Editor - Data type changes - Quiz 7medium Power Query Editor - Filtering rows - Quiz 13medium