With this tutorial, I want to showcase how you can calculate a cumulative run rate into the future based on some historical results.
This was a requirement from the Enterprise DNA Support Forum where a member needed a forecast projection out into the future. Enabling them to compare current results to an average run rate over a certain period of time.
You can view the full forum post here – Projecting current profit run rate
In this tutorial, we cover some unique ideas. First, how to calculate the average run rate and secondly, project this continuously forward so that we can then run the daily comparison versus the actual results as they happen.
We are attempting here to visually make the underlying trend more prevalent than we would ordinarily have if just reviewing daily results with no forecast to compare it to.
The best way to ultimately compare trends is with cumulative totals.
The cumulative total DAX formula pattern that we cover in this video is a little different to the one you may have used in the past.
This is because there’s a different requirement here around how we ultimately calculate the cumulative total for the average daily run rate.
These are such unique tips and concepts which I think you’ll find really valuable.
If you can understand the many concepts covered throughout this tutorial you’re in a very good place as there are so many different ways that you can apply logic like this.
Some related links for you to review that will be helpful in adding further colour to this particular example…
Enjoy working through this tutorial.
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online
Enterprise DNA Events