Tag: Forecasting

How To Create A Forward Forecast In Power BI: Advanced Forecasting Techniques

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

Continue reading

Forecasting Technique: Exploring Forecasting Logic In Power BI Models

If you want to have a real-world example scenario of forecasting using Power BI, you’re in the right page. You’ll find in this tutorial a forecasting technique that you can surely implement in your own work environment. In the example, I compare my actual results to my forecasts and look at them cumulatively. The cumulative

Continue reading

A Deep Dive Into How The ALLSELECTED DAX Function Is Used In Power BI

The ALLSELECTED DAX function inside Power BI is one of the more advanced functions that you can utilize within your reports and dashboards. ALLSELECTED DAX function is a derivative of the ALL functions. So there’s ALL, ALLSELECTED and ALLEXCEPT. They all do something similar, which is remove the context or filters. Here, we’ll focus on

Continue reading

How To Create Budgets With Seasonality Impact Using Power BI

I’m going to show you something specific and quite advanced on budgeting through Power BI. We’re going to dive into how to create budgets with consideration on seasonal impact.  This has great potential mostly because it paves the way for highly effective analysis. It also enables you to automate some of the insights that you

Continue reading

A Power BI Training On Budgeting Scenarios Using DAX

So we’re going to really dive into some problem-solving in this Power BI training. 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

Continue reading