Variables are a real game-changer for the formula bar in Power BI. Being able to break down your more complex formulas in steps makes setting them out that much more intuitive. I keep thinking back to using VBA with these variables. They make your life in VBA about ten times easier – and the same
I really wanted to showcase here how incredible Power BI is as an analytical tool. You can achieve so much that you might never have thought possible. Developing scenario analysis logic within Power BI models is probably my favorite technique to use, mainly because it can be so valuable to the business. Rather than just
Working out your profit margins in Power BI with a basic data set can seem like it requires a few steps. Maybe you think you need to use calculated columns to get the result. Well, you certainly don’t need to do that – there is a much simpler way. Using measures, you can start with
Quick measures in Power BI is a fantastic feature that can increase the speed of development immensely. Here, I review how you can start using them and I look at the many considerations of actually implementing them. Quick measures isn’t perfect but it’s being updated all the time. The Power BI team have made a
In this post, I want to show you what is without a doubt one of the most compelling visualisation techniques in Power BI. Never feel you are confined to use just the general visualisation options inside of Power BI (or custom visuals for that matter). You have a significant opportunity to make your visuals even
