Tag: Variables

Using Variables in DAX – A Detailed Example

Using Variables in DAX - A Detailed Example

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

Continue reading

Develop Advanced Scenario Analysis Models Using DAX in 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