📊Power Query
Also known as Microsoft Power Query, Power Query Editor, Power Query M
A Microsoft tool in Excel and Power BI that gets and cleans data. It saves each step.
Think of it like
It is like a recipe card. You write the steps once, then use them for each new batch.
Example
Each month Emma gets a sales CSV with the same mess. She cleans it once in Power Query. Now each new file takes one click on Refresh.
Why it matters
It turns hours of copy and paste into one click. The steps are the same every time, so fewer mistakes slip in.
Definition
Example code
powerquery
let
Source = Csv.Document(File.Contents("C:\data\sales.csv")),
Headers = Table.PromoteHeaders(Source),
North = Table.SelectRows(Headers, each [region] = "North")
in
NorthCommon mistake
Key takeaways
- 1Steps, not edits. Each change is saved as a step.
- 2Refresh repeats. New data runs the same steps.
- 3Written in M. Every click becomes a line of code.