Tag: Budgeting Analysis

Create Reports In Power BI To Show Deviations And Insights

In this tutorial, I want to show you how to set up compelling visualizations using deviations in your reports in Power BI. You may watch the full video of this tutorial at the bottom of this blog. These are some really powerful insights that have historically been very difficult to complete and highlight in combination.

Continue reading

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

Forecasting in Power BI: Compare Performance vs Forecasts Cumulatively w/DAX

Compare Performance vs Forecasts Cumulatively with DAX

Showcasing results cumulatively is, in my opinion, the best way to showcase trends in your data. When comparing data versus budget or forecasts, showing the trends or divergence in trend is essential. You may watch the full video of this tutorial at the bottom of this blog. You want to make sure you can identify

Continue reading