Tag: Forecasting

Explore Forecasting Logic In Your Power BI Models Using DAX

Explore Forecasting Logic In Your Power BI Models Using DAX

It doesn’t get more real world than the video below for an application of Power BI to provide great insight. In the example I run though here, I want to compare my actual results to my forecasted results. Not only that – I want to view these cumulatively. The cumulative totals give me a much

Continue reading

Forecasting Analysis Techniques in Power BI with DAX

Forecasting Analysis Techniques in Power BI with DAX

Forecasting analysis in Power BI can be completed in quite an effective manner if you utilise the time intelligence functions in DAX effectively. In this example I wanted to run through the many options you have available to start automatically creating forecasts based on historical information. Your forecasts in a lot of cases will be

Continue reading

Deep Dive Into ALLSELECTED – DAX Function In Power BI

Deep Dive Into ALLSELECTED - DAX Function In Power BI

The ALLSELECTED function inside of Power BI is a complex DAX function. It is one of the more advanced functions that you can utilize within your reports and dashboards. In my view, it is one that you have to learn well. You can’t just forget about it and not focus on ways you can utilize

Continue reading

How To Create Budgets Which Have Seasonality Adjustments – Power BI Technique

How To Create Budgets Which Have Seasonality Adjustments - Power BI Technique

We’re going to get advanced today around budgeting in Power BI. Occasionally, you will not actually have some unique budgeting or forecasting data and you need to create it. Most forecast or budgets will likely be created based on historical results in some way. You might do something very simple, like finding the results from

Continue reading

Implement Budgets & Forecasts Automatically in Power BI Using DAX

I’m going to show you with this tutorial how you can create budgets in Power BI that are purely based of historical information and complete it in an automatic way. When you create budgets and forecasts sometimes you may have to go through a very comprehensive process. So this is obviously isn’t going to cover

Continue reading