Bird
0
0

What does the Table.Transpose function do in Power BI's Power Query?

easy📝 Conceptual Q11 of 15
Power BI - Data Cleaning with Power Query
What does the Table.Transpose function do in Power BI's Power Query?
AIt flips rows and columns in a table.
BIt filters rows based on a condition.
CIt sorts the table by a specific column.
DIt merges two tables into one.
Step-by-Step Solution
Solution:

  1. Step 1: Understand the function purpose

    Table.Transpose is designed to switch rows and columns in a table.

  2. Step 2: Compare with other options

    Filtering, sorting, and merging are different operations not related to transposing.

  3. Final Answer:

    It flips rows and columns in a table. -> Option A

  4. Quick Check:

    Transpose = Flip rows and columns [OK]
Quick Trick: Transpose means flip rows and columns [OK]
Common Mistakes:
  • Confusing transpose with filtering or sorting
  • Thinking transpose merges tables
  • Assuming transpose deletes data

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Data Cleaning with Power Query - Handling null and blank values - Quiz 5medium Data Cleaning with Power Query - Header promotion - Quiz 10hard Data Cleaning with Power Query - Pivoting columns - Quiz 12easy Data Cleaning with Power Query - Why clean data drives accurate reports - Quiz 11easy Data Cleaning with Power Query - Removing duplicates - Quiz 6medium Formatting and Design - Page layout and canvas settings - Quiz 9hard Getting Data - Web data import - Quiz 4medium Power BI Basics and Architecture - First Power BI report - Quiz 14medium Power BI Basics and Architecture - Power BI installation and setup - Quiz 9hard Power Query Editor - Column operations (rename, remove, reorder) - Quiz 9hard