Tag: Forecasting DAX

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

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