help with partial total to cohort

Hi diogonesbitt,

I have already added the year column as a filter in the formula, so it will only calculate the value within the same year range, and if you woud like to sum the value in month range, create a column which format with year and month with the date column, then use that column as a filter.

GroupTotal = sumx(

                   filter(

                      'Table',

                       And('Table'[Mes]=earlier('Table'[mes]),

                                 ‘Table’[Ano]=Earlier(‘Table’[Ano]))

                           ),

                   'Table'[Count of id])

Regards