Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Reverse cumulative sum - to count dates

Hi there community


I am trying to figure out how to create a reverse cumulative sum that counts dates. I'd be grateful if anyone could help me with a Powerquery or DAX solution.




Required output in PowerBI (assuming today's date is 2/10/23):




Super User
Super User

Hey @matt0902 ,


please explain

  • from where the 28th of September is comin
  • why there is India with 3rd of October
  • why the the Forecast rev **bleep** is 2 for France at the 1st and 2nd of October.



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi Tom


The Forecast Date is when a defect is planned to be closed. The Actual Date is when the defect was closed. The reverse cumulative sum tracks the number of defects not yet closed over time (Forecast is the plan and Actual is the actual). I have included France and India to provide functionality to filter by a field - this could be a range of fields associated with the dataset e.g. country, location, responsible person, subsystem. Here are some example charts that I am trying to reproduce using the above data. This indicates that we are broadly on track to close everything as planned. Normally I would have a much bigger dataset so an extrapolation of the actual line into the future would be more reliable.










Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors