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
I want to share with you a Power BI DAX formula technique to show growth performance effectively. In this tutorial, I’m going to demonstrate how it’s done, but there are so many different scenarios where you want to represent growth and this is just one example. The technique that I’m going to go through can
Here we’re going to look at customer margin contraction. We’re going to try and work out what customer margins are contracting and why are they contracting. Is it because of their purchasing frequency? Is it because of the products they’re buying? Or because of some other reason? We’re going to solve this analytical problem with
In this post, I run through how to use SAMEPERIODLASTYEAR, a time intelligence function, to compare results from this year with those of last year. If you want to start creating compelling reports with strong insights into information over time, then you’ve got to know how to use all the variations of time intelligence functions.