1 Table of Contents: “... Importing Data into Power BI Cleaning Data with Query Editor Transforming Data with the M Language Using...”

2 Table of Contents: “...Query foldingM query structure; Lazy evaluation; There's more ... ; Partial query folding...”

3 Table of Contents: “...Planning Power BI projects -- Connecting to sources and transforming data with M -- Designing...”

4 Table of Contents: “... and Transforming Data with M Designing Import, DirectQuery, and Composite Data Models Developing DAX Measures...”

5 Table of Contents: “... transform; M formula language; #shared; Summary; Chapter 3: Building the Data Model; Building relationships...”

6