Category: Time Intelligence

Compare Multiple Metrics Cumulatively In Power BI Using Advanced DAX

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?

Continue reading

Advanced Analytics in Power BI: Layering Multiple 'What If' Analysis

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

Continue reading

Analysing Customer Trend Using DAX In Power BI

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

Continue reading

Calculate Rolling Totals Using DATESBETWEEN In Power BI

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

Continue reading

Creating Forward Forecasts in Power BI Using DAX

How to Create Forward Forecasts in Power BI Using DAX

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

Continue reading