Regarding Cumulative sum

[yugofukuda]

Hi,

I would like to use max number of the cumulative sum on each day of each month but i can´t understand how to deal with it by using Dax. For example, in the case of August, i would like to put 994 on each day and in the case of July, the number is 2,300 on each day.

I already serched some ways but it didn´t work.

 I would be appreciated if you could help me! Thank you ! 

[MattAllington · Accepted solution]

Assuming the total never goes backwards (no negative days), you can only use the maximum and ignore the day. Something like that, depending on the names of your tables.

•calculate(sum(table[value]),all(calendar[day]))

this formula ignores the filter coming from the "day", but respects the filter coming from yyyy-mm

[yugofukuda]

HI Matt,

Thank you very much!! it worked well!!!!!!!!!!!!!!!