Food Hygiene – Making the model
No matter how you get your data together (and this is one of the strengths of the Power Suite) you …
DAX
Weekend Work 26 – A Random Warning
As we come to the ends of our season with Weekend Work, there are some lessons to consider at this …
Weekend Work 025 – Calendars & Performance
It is not uncommon for a business to not just use the simple 12-month calendar we are used to in …
Weekend Work 024 – Unichar and review
UNICHAR ( ) allows you to add symbols into your reports; these can augment your measures to help make it …
Weekend Work 023 – Switching Parameters
What if parameters are a vital part of starting to build forecasting scenarios. In many ways the best way to …
Weekend Work 022 – Dates and Dashboards
Starting to use Dashboards is a major maturity step change within Power BI, it marks the change from using just Power BI Desktop to an integrated service based strategy.
The issue with DateTime is mentioned a lot on the forums, but often it doesn’t fully explain the why.
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.
Weekend Work 019 – Mistakes
Mistakes in Power BI are normal and part of your growth and development. Where these mistakes hurt you is when you unintentionally either slow down your solution and limit its capacity for expansion.
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 017 – Time Intelligence in DAX and a Peek at Demo 1
This week we looked at Time Intelligence within Power BI. Time Intelligence Calculations are something that you will find you …