Tag: Power BI

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

Announcement – Enterprise DNA Referral Program

Welcome to the Enterprise DNA Referral Program! Most of you are probably aware already of why I started Enterprise DNA. But for the benefit of those who are new to my blog, let me reshare my purpose for launching this platform. Historically I have been in the finance world and reporting and analytics was always

Continue reading