Tag: DAX

Develop Advanced Scenario Analysis Models Using DAX in Power BI

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

Continue reading

Calculating Percent Profit Margins Using DAX in Power BI

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

Continue reading

Quick Measures Deep Dive – How To Use Them in Power BI Models

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

Continue reading

Creating Multi Threaded Dynamic Visuals – Advanced Power BI Technique

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

Continue reading