Tag: Advanced DAX

Create A New Table In Power BI: How To Implement Budgets & Forecasts Automatically Using DAX

In this blog post, I’m going to show you how you can create a new table in Power BI that is purely based on historical information and complete it in an automatic way. When you create budgets and forecasts, sometimes you may have to go through a very comprehensive process. I’m going to demonstrate a

Continue reading

Using Multi-Layered Scenario Analysis in Power BI

I’m huge on scenario analysis in Power BI. Being able to input variables inside your calculations that you can ‘shock’ to effectively predict outcomes is so powerful when trying to make decisions. In Power BI you can complete this really efficiently, and you can combine many of the formula techniques with your data models and

Continue reading

Last Purchase Date in Power BI: When Did Your Customers Make Their Last Purchase?

It’s the goal of every organization to see their business become successful. That said, understanding customer behavior deeply is one of the elements you can leverage for increased business success. One way to do this is by knowing your customers’ last purchase date in Power BI. In this blog post, I am going to demonstrate

Continue reading

Create Dynamic Lists of Dimensions using DAX in Power BI

Create Dynamic Lists of Dimensions using DAX in Power BI

Have you ever wanted to showcase the top three, five, or ten best results across a particular dimension? Well, in this video I’m going to show you exactly how you can do that with a specific example. The example we’re going to work through is one where I want to find my top three salespeople

Continue reading