Tag: Variables

How To Use The EARLIER Function In Power BI – A DAX Tutorial

Most DAX beginners and even intermediate users really struggle in understanding what the EARLIER function does. It also took me a long time to understand how, when and why you should use this function in Power BI. In this article, we are going to complete a deep dive into using the EARLIER function. I’ll show you

Continue reading

Using Variables In Power BI – A Detailed Example

How To Use Variables In DAX Power BI

In this post, I’ll show you how to use variables within your DAX formula in Power BI. 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 much more intuitive. I keep thinking back to using VBA with

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