Being able to create cumulative totals bar graph without changing dataset

[Lisipowerbi]

Hi everyone,

I am trying to create a bar graph where every month the data is cumulative, currently I manage to have a monthly total but I would like to have it add on afterwards:

 

Where October shows total for October but than November shows total for October + November. 

Can anyone help how to do this? 

These are my current settings:

 

[Lisipowerbi]

@Greg_Deckler 

I actually managed to do the running total using CALCULATE - my issue now is that I need this for a given time range only. Showing you an example below:

 I would like the running total to only start calculating when needed (managed to simply do this using a fitler on the visual for the actual count) but I don't know how to add this date range filter to my CALCULATE function:

Running Total FY1 = CALCULATE(SUM('sheet (2)'[# of events]), FILTER(ALL('sheet (2)'), 'sheet (2)'[CreatedDate].[Date]<= MAX('sheet (2)'[CreatedDate].[Date])))

Any advice?

[Greg_Deckler]

@Lisipowerbi Well, in theory:

Running Total FY1 = CALCULATE(SUM('sheet (2)'[# of events]), FILTER(ALL('sheet (2)'), 'sheet (2)'[CreatedDate].[Date] >= DATE( 2023, 10, 1) && 'sheet (2)'[CreatedDate].[Date]<= MAX('sheet (2)'[CreatedDate].[Date])))

[Lisipowerbi]

Thanks this works but I would need to only show until "Today" if possible. I tried this:

Running Total FY = CALCULATE(SUM('spotmecom-analytics-powerbi-handler (2)'[# of events]), FILTER(ALL('spotmecom-analytics-powerbi-handler (2)'), 'spotmecom-analytics-powerbi-handler (2)'[CreatedDate].[Date]>=DATE(2023,10,1) && 'spotmecom-analytics-powerbi-handler (2)'[CreatedDate].[Date]<=TODAY() && 'spotmecom-analytics-powerbi-handler (2)'[CreatedDate].[Date]<=MAX('spotmecom-analytics-powerbi-handler (2)'[CreatedDate].[Date]))) 

---

But the visualization still takes the end of the year into consideration - would you happen to know why? 

Thank you for all your help!!

@Greg_Deckler

[Greg_Deckler]

@Lisipowerbi Better Running Total - Microsoft Fabric Community