I’ve previously showcased how you can compare your actual results versus your budgeted results using advanced DAX. But, what if you also wanted to overlay some time comparison information so you’re comparing your actuals versus budget versus last year? Or perhaps versus last quarter? Or against any other time period you may want to select?
In this tutorial, I show you how you can layer multiple “What If” analysis or scenarios in Power BI, one on top of each other. It takes your analytical output through the roof if you use this technique effectively. As you likely know, I am a huge promoter of scenario analysis in Power BI. Scenario
In this tutorial, we’re really going to use Power BI as an analytical tool to analyse customer trend. We’re going to work out how we can find our customers that are purchasing behind trend. We want to know this so we can keep a really close eye on how our customers’ purchases are going. We
Here I’m going to show you how you can calculate the amount sold between two different dates using the DATESBETWEEN function in Power BI. Another way to think about this is calculating rolling sales or running totals. We need the calculation to be dynamic, so that as we move through time, we have a number
In this blog, we’re going to go over how you can create automated forecast from historic data in Power BI. This is common in businesses to make forecasts and budgets. Now, have you ever wanted to create automatic forecasts based on historical information? In the past, this was relatively difficult to do using tools like
