Introduction to Power Query M
This tutorial provides an in-depth look at Power Query M, a formula language used to shape and transform data within Power BI. Learn to use M to build robust data models and unlock the full potential of your data.
Key Concepts
- Data Shaping: Modify the structure and format of your data.
- Data Transformation: Change the values and characteristics of your data.
- Data Modeling: Build relationships between tables for efficient querying.
Getting Started
Before you begin, ensure you have Power BI Desktop installed. You'll need to create a new Power BI report and open the Power Query Editor. This editor is where you'll write and execute your M code.
Example: Filtering a Table
let
Source = Excel.CurrentWorkbook(){"Name":"MyData"},
FilteredRows = Table.SelectRows(Source, each [Sales] > 1000)
in
FilteredRows