Power BI - Data Cleaning with Power Query
Which of these is the correct M code snippet to pivot a column named 'Month' with values from 'Sales'?
Which of these is the correct M code snippet to pivot a column named 'Month' with values from 'Sales'?
easy📝 Conceptual Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Understand Table.Pivot syntax
Table.Pivot requires source, list of pivot values, pivot column, value column, and aggregation function.Step 2: Identify correct parameters
Table.Pivot(Source, List.Distinct(Source[Month]), "Month", "Sales", List.Sum) correctly uses List.Distinct(Source[Month]) and List.Sum aggregation.Final Answer:
Table.Pivot(Source, List.Distinct(Source[Month]), "Month", "Sales", List.Sum) -> Option AQuick Check:
M pivot syntax = Table.Pivot(Source, List.Distinct(Source[Month]), "Month", "Sales", List.Sum) [OK]
Quick Trick: Pivot needs aggregation function in M code [OK]
Common Mistakes:
- Omitting aggregation function
- Swapping pivot and value columns
- Using incorrect List.Distinct syntax
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