Tag: Measure Branching

Develop Advanced Scenario Analysis Models Using DAX in Power BI

By Sam McKay, CFA on January 16, 2019July 17, 2019

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

Posted in: DAX, Measure Branching, Measures, Parameter Tables, Power BI, Scenario Analysis, Variables

Business Intelligence DAX Enterprise DNA Power BI Scenario Analysis

Calculating Percent Profit Margins Using DAX in Power BI

By Sam McKay, CFA on January 14, 2019July 17, 2019

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