Tag: Budgeting in Power BI

Power BI Budgeting Technique: Allocating Monthly Budgeting Sensitivity Table

In this blog, I talk about a technique around Power BI budgeting, working out a way to allocate calculations across different time frames or months, for example. In most cases, budgets are in a yearly basis. However, it’s so much better to narrow it down to a monthly basis and see the allocation of our

Continue reading

Creating Virtual Relationships In Power BI Using The TREATAS Function

The TREATAS function in DAX is one of the most interesting DAX formulas that you can utilise inside your Power BI models. It has a very specific usage that can be beneficial if you are looking to simplify your data model and DAX formulas. In this tutorial, I’m going to show you how we can

Continue reading

Compare Actual Results to Budgets Using Power BI Forecasting

Budgeting-Examples-in-Power-BI-and-DAX

Budgeting in Power BI is just not that easy to implement. I wish it was as easy as bringing in your actuals and budgets and then like magic you would be able to see the insights you need visualized in a compelling way simply by using Power BI forecasting. That’s why I created this blog

Continue reading