Weekend Work 020 – Next Level
In the last two weeks we have looked at measures and the ETL process and parts of M in Query Editor, now it is time to start to look at the next level of this. Levelling up our queries both in DAX and M.
m Script
Weekend Work 018 – Always circle back
It is an important step to be prepared to revisit lessons and see how they look now you know more. …
Weekend Work 012: Another Spreadsheet + My First Filter (in Calculate)
This week we covered a new Spreadsheet that you may want to make part of your Global Due Diligence Process and then looked at how Filter Context can work against you, showing why it is so important to be sure about what your measures are doing.
Weekend Work 011: DAX to M + Tooltips and Drills
We’re really exploring the NYC Water Tower Inspection data. This week we go through the process of “Upgrading” our data model to move Calculated Columns into the M using the Query Editor. We then explore using Tooltips and Drill-down within Power BI
Weekend Work 010: Importing Excel and the basics of KPI’s
When you’re developing solutions in the real world you have to start somewhere often times that will be a pre-existing …
Read moreWeekend Work 010: Importing Excel and the basics of KPI’s
Weekend Work 009 – The flow of data and non-data in Power BI
Data Flows in Power BI Disconnected Tables/Slicers This week we revisited a great Dataset – New York Rooftop …
Read moreWeekend Work 009 – The flow of data and non-data in Power BI
Weekend Work 008 – Excel in Power BI
The first step into the Power BI Ecosystem Weekend Work 008 – Next steps within Excel Power BI …
Weekend Work 007 – Plan Survival & Tables of measures
No Plan Survives “No plan survives contact…” It’s become such a truism of life and it holds true in …
Read moreWeekend Work 007 – Plan Survival & Tables of measures
Weekend Work 006 – Context and bases
Query Editor – Establish a base When you first start using Power BI for any data invariably you will …
Weekend Work 005 – Steps and Formatting
Query Editor – Applied Steps Query Editor in Power BI and Excel PowerQuery allows you to see what has …
