Copyright (c) 2026 MindMesh Academy. All rights reserved. This content is proprietary and may not be reproduced or distributed without permission.
2.3.1. Power Query (M) Transformations
💡 First Principle: Power Query (M) is a functional language optimized for data transformation. It's the engine behind Dataflow Gen2 and Power BI data preparation.
Common M Transformations
| Operation | M Function | Purpose |
|---|---|---|
| Filter rows | Table.SelectRows | Remove unwanted records |
| Remove columns | Table.RemoveColumns | Eliminate unneeded columns |
| Merge queries | Table.NestedJoin | Join tables together |
| Group by | Table.Group | Aggregate data |
| Pivot | Table.Pivot | Transform rows to columns |