As you likely know, I am a huge promoter of scenario analysis in Power BI. Scenario analysis is an amazing analytical technique you can use in Power BI that virtually allows you to predict what might happen in the future. In this tutorial, I explain how you can layer multiple scenarios, one on top of
We’re really going to use Power BI as an analytical tool today. We’re going to work out how we can find our customers that are purchasing behind trend. You will want to know this so you can keep a really close eye on how our customers’ purchases are going. We know that our top customers
Here I’m going to show you how you can calculate the amount sold between two different dates. 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 that re-calculates based on the time frame
Have you ever wanted to create automatic forecasts based on historical information? In the past, this was relatively difficult to do using tools like Excel but I’m going to show you in this video tutorial how you can do this in an almost automatic way inside of Power BI. What we’re going to do is
