Running total of days per month

[elguestca1]

Hello,

I faced an issue which I can not really understand. I need a measure to calculate running total of days to use it in another formula. So for this year it should look like this.

I have a date table and there are several ways to show in visual how many days did the month have. I could use MAX, if the date table format gives number of day for specific month or I could use DISTINCTCOUNT if the days are returned for a year. In both cases I get the correct data in visual.

When I try to make a running total calculation of days as it is shown above, I try to use the Running Total Quick Measure option, which actually works fine with let's say Sales, but it does not with the days calculation. I believe it has something to do with that we use SUM for Sales and MAX/DISTINCTCOUNT for the days.

Maybe you know how to write this kind of measure as in example above?

Thank you.

[Greg_Deckler · Accepted solution]

@elguestca1 Better Running Total - Microsoft Fabric Community

[elguestca1]

@Greg_Deckler awesome, thank you!