Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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:
@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])))
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!!
@Lisipowerbi Better Running Total - Microsoft Fabric Community