Power BI - Data Cleaning with Power Query
In Power Query M language, how do you correctly apply the
Table.Transpose function to a table variable named CustomerData?In Power Query M language, how do you correctly apply the Table.Transpose function to a table variable named CustomerData?
easy📝 Conceptual Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Identify the function usage
TheTable.Transposefunction takes a table as its single argument.Step 2: Apply the function correctly
Use parentheses to pass the table variable:Table.Transpose(CustomerData).Final Answer:
Table.Transpose(CustomerData) -> Option CQuick Check:
Function call syntax with parentheses is standard in M language. [OK]
Quick Trick: Use parentheses to pass tables to functions [OK]
Common Mistakes:
- Using square brackets instead of parentheses
- Using curly braces which are for lists
- Using arrow notation which is invalid here
Master "Data Cleaning with Power Query" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes