Tag: Forecasting Power BI

Allocate Monthly Forecasts Across Daily Results In Power BI Using DAX

Allocate Monthly Forecasts Across Daily Results In Power BI Using DAX

In this example, we’re doing a deep dive into budgeting and forecasting inside of Power BI. Specifically, I want to show you how you can allocate budgets (or forecasts) which might be at a monthly or a yearly level, and you need to allocate them to a daily level. This scenario is very common when

Continue reading

Budgeting Performance Segmentation Using DAX In Power BI

Budgeting Performance Segmentation Using DAX In Power BI

When working on budgeting analysis inside of Power BI, there may be situations in your work where you want to segment the results into different groups, so that you can analyse which performers were better than others, versus their targets for example. This is some very unique analytics that can be done inside of Power

Continue reading

How To Calculate Budget Or Forecast Results Cumulatively In Power BI

Recently I ran an entire workshop as part of the Enterprise DNA webinar series on Advanced Budgeting Techniques. I know for a fact that there’s a huge requirement for this type of analysis in Power BI. Very often we have our actual results and we want to compare them to a forecast or a budget

Continue reading