Cumulative measure per day y MTD

[Syndicate_Admin]

Good morning

I'm trying to put the accumulated charges per day, each day in a column, and per month, when the month changes I need it to start from 0.

I have first created a measure that is the accumulated data:

Cumulative = calculate(sum(Query1[collections]), FILTER(all(Query1[Date].[ Date]),Query1[Date]. [Date]<=max(Query1[Date].[ Date])))

And then I used the formula Month to date, including the previous measure

Mov_MTD = CALCULATE(Query1[Cumulative], DATESMTD(Query1[Date]))

So I get what I need exactly except that when one day there are no charges the box goes blank and then it does not serve me. I need it to be filled in also every day whether there are payments or not, if on the 5th of the month there has been no charge that puts the data of day 4, since the accumulated to day 5 will remain the same as day 4.

I don't know if I explain.

Someone knows how he could do it???

Thanks a lot!!

[v-xulin-mstf]

Hi @Syndicate_Admin,

Could you provide sample data and expected output after removing sensitive data?
Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.