In this blog post, I will showcase some of the analytical work I enjoy doing the most… and that is working on future predictions using Power BI DAX functions. I am always fascinated with trying to understand what could happen in the future. I’ll show you a technique around how you can almost predict future
Tag: Forecasting
In this blog post, I’m going to show you how you can create a new table in Power BI that is purely based on 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. I’m going to showcase a
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
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
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