Forum Discussion
Regarding Cumulative sum
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 !
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
2 Replies
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
HI Matt,
Thank you very much!! it worked well!!!!!!!!!!!!!!!
