Weekend Work 006 – Context and bases
Query Editor – Establish a base When you first start using Power BI for any data invariably you will …
m Script
Weekend Work 005 – Steps and Formatting
Query Editor – Applied Steps Query Editor in Power BI and Excel PowerQuery allows you to see what has …
Weekend Work 004 – Dealing with errors is so average
Dealing with Errors DAX and Average Summary When you start to get more active within Power BI and …
Weekend Work 002 – Find and Replace and Divide
Query Editor – Find and Replace Report Layer – Divide Within Query Editor you can quickly create functions, …
Weekend Work 001 – Unpivot and basic aggregations
Query Editor – Unpivot your data Report Layer – Basic aggregations When you first start with Power BI, these …
Dataset 009 – Pull it together
Having captured the data and imported it into Power BI Dataflows now it is time to pull everything together …
Sorting through the mess
Week 2 – We’re looking at some of the tough work that has to be done to cleanse a dataset …