Reference
Keyboard shortcuts
| Shortcut |
Action |
Where |
| Ctrl+T |
Convert a range to a table |
Excel |
| Ctrl+Shift+L |
Turn filters on or off |
Excel |
| Ctrl+Z |
Undo the last action (not available in Power Query) |
Power BI |
| Ctrl+A |
Select all items in a column |
Power Query |
| F2 |
Rename the selected query |
Power Query |
Key terms
| Term |
Meaning |
| Power BI Desktop |
The free Windows program. You build reports here. |
| Power Query |
The data preparation tool inside Power BI. It cleans and combines data. |
| M language |
The code language behind each Power Query step. |
| DAX |
Data Analysis Expressions. The formula language for measures and columns in Power BI. |
| Measure |
A calculation that shows a result in a visual. Example: Total Sales. |
| Calculated column |
A new column added to a table with a DAX formula. |
| Distinct |
All values in a list, with duplicate values counted one time. |
| Unique |
Values that appear only one time in the whole list. |
| Star schema |
The data model shape: one fact table in the center, dimension tables around it. |
| Fact table |
The table with numbers and transactions. Example: Sales. |
| Dimension table |
The table with descriptions. Example: Products, Customers. |
| Cross filtering |
Clicking one visual filters the other visuals. |
Trainer's resource links
These links came from the trainer's Zoom chat.
| Link |
Topic |
| https://chat.whatsapp.com/JzqyzZnbmdoL9vE7wkUMmv |
WhatsApp group invite |
| https://drive.google.com/drive/folders/14ABbcE8phihoQXBJkPawOm2aJ99FWjHx |
Training materials folder |
| https://docs.google.com/spreadsheets/d/1lNFfOYzhgHWr4GBSfl3lI-sr8i5avbBLnp7Y04qqo5w |
Training spreadsheet |
| https://www.california-demographics.com/cities_by_population |
City population source data |
"Screenshot in Zoom chat" moments
The trainer annotates the screen first. Then the trainer shares the
screenshot in the Zoom chat. This table lists every moment. The guide
pages show the screen frames.
| Topic |
Guide page |
| Power BI Options slides (part 1) |
Page 2 |
| Power BI Options slides (part 2) |
Page 2 |
| Distinct vs unique |
Page 5 |
| Append as New |
Page 8 |
| Conditional column and errors |
Page 11 |
| AI workflow: TMDL script, 10 steps |
Page 14 |
| Align and distribute the visuals |
Page 16 |
Recording outline
The topics below follow the order of the recording.
| Topic |
| Introduction and setup |
| Power BI Desktop and Power BI Service |
| Pricing and license types |
| Trainer shares the Power BI Options slides |
| Training materials folder link |
| Excel: convert raw data to a table |
| Trainer shares the Power BI Options slides (part 2) |
| Training spreadsheet link |
| Open Power Query |
| Power Query window layout |
| Distinct vs unique explained |
| Trainer shares the distinct vs unique screenshot |
| Remove columns in Power Query |
| M language and no undo |
| Transform vs Add Column |
| Break |
| Combine data (append) |
| Trainer shares the append screenshot |
| Data update flow |
| M language calendar table |
| Trainer's calendar table code request |
| Web data: California population |
| Merge tables (lookup) |
| Join kinds |
| Conditional column and errors |
| Replace errors |
| Close and Apply: load the data |
| Relationships and cardinality |
| Break |
| Recap of the morning |
| Why write DAX measures |
| Measures vs calculated columns |
| First measure: Quantity Sold |
| SUMX: Total Sales |
| RELATED: Total Cost |
| Total Profit and Profit Margin |
| COUNTROWS: Total Transaction |
| Date hierarchy and interaction |
| TMDL script export |
| AI workflow steps (screenshot in chat) |
| AI tool disclaimer |
| Sales LY and Sales YTD verify |
| Format the measures |
| Bulk format in Model view |
| SWITCH: price category |
| DAX vs Power Query |
| Dashboard preview and plan |
| New page: Dashboard |
| Title and text box |
| Buttons and hover styles |
| Slicers: county, quarter, year |
| KPI cards |
| Align and distribute |
| All charts at one time |
| Align screenshot share |
| Add data to every chart |
| Filters: top 10 |
| Data labels and trendline |
| Edit interactions |
| Detail and Tips pages |
| Drillthrough page |
| End of the recording |
Source
This guide is based on the webinar recording "WEBINAR POWER BI" by
Digital Analytic Solution (19 September 2026).
- The recording ends at the drillthrough step.
- The class plan includes publish to the Power BI Service. The recording
does not show this part.