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