Forum Discussion
Solved
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 ...
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
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!!!!!!!!!!!!!!!
