How To Calculate A Cumulative Run Rate In Power BI Using DAX

Enterprise DNA Forum post - forum.enterprisedna.co/t/projecting-current-pro…

When analyzing actual results in your data you may sometimes want to compare it to a forecast or run rate.

In this particular example from the Enterprise DNA Support Forum, a member asked can you take the current results and then somehow project them out for the rest of the year cumulatively.

In Power BI you certainly can and this is what this tutorial will showcase to you.

Enjoy!

Sam


*****Video Details*****
0:16 - Introduction
1:25 - Working Out The Cumulative Total
2:24 - Working Out The Run Rate
5:26 - Calculating Cumulative Run Rate
6:57 - Conclusion

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-gu…
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-gu…
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-do…
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/

***** Related Links *****
Create Dynamic Cumulative Totals Using DAX In Power BI
blog.enterprisedna.co/create-dynamic-cumulative…
Running Totals In Power BI: How To Calculate Using DAX Formula
blog.enterprisedna.co/running-totals-example-in…
Compare Cumulative Information Over Different Months In Power BI
blog.enterprisedna.co/compare-cumulative-result…

***** Related Course Modules *****
Time Intelligence Calculations
portal.enterprisedna.co/p/time-intelligence-cal…
Budgeting & Forecasting
portal.enterprisedna.co/p/budgeting-and-forecas…
Mastering DAX Calculations
portal.enterprisedna.co/p/mastering-dax-calcula…

***** Related Support Forums *****
Projecting Current Profit Run Rate
forum.enterprisedna.co/t/projecting-current-pro…
Find The Max In A Column Function
forum.enterprisedna.co/t/find-the-max-in-a-colu…
Rolling Estimate Calculation
forum.enterprisedna.co/t/rolling-estimate-calcu…
For more run rate queries to review see here…..
forum.enterprisedna.co/search?q=run%20rate