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
Whenever I think of row level security I think scale. There’s probably no better feature in Power BI for organisations. Instead of having to develop ten different reports for every sale region or for each different sales department, you can just create one detailed Power BI model and use row level security to make sure
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
