DAX YTD & LYTD

Posted on

DAX for Financial Years I use these two measures quite a bit. YTD Total Sales is straight forward and calculates in this case a sum of sales from the 1st of July to today. The trick is what to do when you want to compare the same period for the previous year. That is where […]

Canva + Power BI

Posted on

Background Concepts for Power BI Recently I read an article on background concepts for Power BI by Chris Hamill. It touched on the importance of a report background and its role within data storytelling. It then gave a tutorial on how to create a PowerPoint background for Power BI. It really is a great article […]

5 Tips to a Successful Side Hustle

Posted on

I have now been running my side hustle for 1 year now and I don’t think I have ever learnt so much. There are so many varied skills required but here is my top 5 that I believe will set you on the right path for a successful side hustle. 1. Personal Brand My number […]

Top 50 Websites – Bubble Chart

Posted on

This Power BI Freebie is an interesting look on the top 50 websites. It is using “Bubble chart by Akvelon” which allows you to place an image in a bubble chart. I am also using the same image url in the table. I had a bit of fun creating this one so I hope you […]

DAX COALESCE

Posted on

DAX, the COALESCE function Don’t you hate it when a card looks like this? Meet COALESCE This function was introduced in March 2020 and instantly became a favourite of mine.  Although I think a more appropriate name would be ifblank! Wrap it around your DAX statement and the Default Measure will be presented instead of […]