Completing budgeting analysis in Power BI is unfortunately just not that easy. What I’m going to go through today is possibly the most advanced technique that you can get to with budget analytics as we need to incorporate some seasonality into our budgeting numbers. I detail this quite extensively in the video tutorial, so there’s
Here I’m going to show you how to use the function AVERAGEX with DAX in Power BI. By learning and understanding how to use this function, you very quickly open up a range of analysis that can be incredibly insightful and valuable. Maybe you want to work out the average sales you make per day,
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
