Tag: Budgeting

Budgeting Scenarios In Power BI Using DAX

So we’re going to really dive into some problem-solving here. This is some really great stuff that you can do with Power BI, but if we just step back for a moment, the key here is, first of all, you’ve got to be able to think analytically. And that’s what I want to do initially.

Continue reading

Advanced Budgeting Insights in Power BI – FREE Training Workshop

The next free training workshop in the Enterprise DNA webinar series is here. You can register here – Advanced Budgeting Insights in Power BI The virtual workshop session will run for between 45-60 mins We are going to dive into various advanced budgeting techniques in Power BI during this one. Budgeting in Power BI is

Continue reading

Compare Multiple Metrics Cumulatively in Power BI using DAX

I’ve previously showcased how you can compare your actual results versus your budgeted results. 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 video

Continue reading

Compare Performance vs Forecasts Cumulatively w/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 want to make sure you can identify when your performance is breaking down as soon as possible and by viewing this cumulatively

Continue reading