Category: Time Intelligence

Layering Multiple ‘What If’ Parameters For Advanced Analytics in Power BI

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

Continue reading

Customer Trend Analysis in Power BI Using DAX

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

Continue reading

Calculate Rolling Totals in Power BI Using DAX

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

Continue reading

Create Dynamic Forward Forecasts in Power BI with DAX

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

Continue reading