Forum Discussion

yugofukuda's avatar
yugofukuda
Icon for Helper IV rankHelper IV
6 years ago
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 ...
Need Help
  • MattAllington's avatar
    MattAllington
    6 years ago

    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

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
yugofukuda
Icon for Helper IV rankHelper IV
6 years ago

HI Matt,

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