Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Cumulative count in matrix filtered by date

Good afternoon, I would appreciate it very much if you can help me The case is as follows: I have two tables with data The first table is: from where we will take the categories for...
danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi Syndicate_Admin ,

 

You can do something like

cumulative sum =
CALCULATE (
    SUM ( table[value] ),
    FILTER (
        ALL ( table[date] ),
        table[date] <= MAX ( table[date] )
    ) //to create a sum of values where  date is less than or equal to the date in the current filter context
)
  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    Thank you very much, I already tried the formula, but it does NOT work, for some reason I accumulate the figures since 2020 by category but does not filter me those of the month.