Tag: FILTER DAX

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

By Sam McKay, CFA on July 25, 2019October 25, 2019

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

Posted in: Average Daily Run Rate, Cumulative Projection Power BI, Cumulative Total Forecast, Cumulative Total Pattern, Cumulative totals DAX, Dynamic Cumulative Total, FILTER DAX, Forecast Cumulative Total, Forecast Run Rate Power BI, Power BI, Power BI Run Rate, Project Run Rate Power BI, Run Rate DAX, Run Rate Power BI, Run Rate Projection, SUMMARIZE DAX

Business Intelligence DAX Power BI Time Intelligence

Create Dynamic Cumulative Totals Using DAX In Power BI

By Sam McKay, CFA on July 8, 2019July 17, 2019

In this tutorial, we’re going to do a deep dive into the cumulative total formula combination that can be used in Power BI. Cumulative totals are a great way of showing trends over time and then also showcasing differences in trends between different timeframes. There is a common combination of DAX functions to use that