changing context to last month dax

[Ritaf]

Hi, 
I have a table with cars transactions by month like below:

carID	Monthly_KM	month of transaction
1	1000	01/01/2020
1	1500	01/02/2020
1	1300	01/01/2021
2	1400	01/01/2020
2	800	01/01/2022

I am trying to bin cars by average km yearly, and when I visualize it in yearly granularity I want to count the cars of last month with the transaction. For example, in 2020 it is December and in 2021 it is April.
the counting with classifications working great and shows the right numbers on monthly granularity, but I have a problem, to filter for "last transaction's" month when it is a yearly granularity.  My formula is:

kmGroup =

SUMX('KM bins table''', COUNTROWS(FILTER('cars',[kmAverage]>'KM bins table'''[Min] && [kmAverage]<'KM bins table''[max])))
How can I fix it to show me the last month on yearly granularity (I have a date table)

Thank you, Rita

[Ritaf · Accepted solution]

I solved it by myself with:

Fitered KM_group =

CALCULATE([kmGroup],LASTNONBLANK('Calendar[date]',[cars quantity])