Power QueryExercises

Module 1

How Power Query thinks

Sources, previews and applied steps: why every transformation is a repeatable recipe.

You'll be able to

Lessons

  1. 1.Applied steps are a recipe, not a one-off editExplain how applied steps chain together and why that makes queries repeatable.
  2. 2.Step order mattersPut cleaning, filtering and aggregating steps in an order that gives correct results.
  3. 3.Power Query in Excel and Power BI: same engine, different hostsTell which behaviour belongs to the M language and which belongs to the host application.
  4. 4.Read the M behind the Applied StepsRead a generated query and say what each step does and which step it depends on.

Take the how power query thinks quiz (8 questions)

Exercises