Help required to count rows in table from last month and from 2 months ago

[jnbelair85]

Hello,

I had found a measure that worked fine until 2023 came and now my following formulas dont work as the last month and 2 months ago fall in 2022. I want to count the number of rows from my tables that have a date in the current month, last month and two months ago.

Here is my current month:

This month = CALCULATE(COUNTROWS('boite support mobilité') , FILTER(ALL('boite support mobilité'[DateTimeReceived]),MONTH('boite support mobilité'[DateTimeReceived]) =MONTH(TODAY())))

Here is last month:

Last month = CALCULATE(COUNTROWS('boite support mobilité') , FILTER(ALL('boite support mobilité'[DateTimeReceived]),MONTH('boite support mobilité'[DateTimeReceived]) =MONTH(TODAY())-1))

Two months ago:

Two months ago =  CALCULATE(COUNTROWS('boite support mobilité') , FILTER(ALL('boite support mobilité'[DateTimeReceived]),MONTH('boite support mobilité'[DateTimeReceived]) =MONTH(TODAY())-2))

I need a way to add the year roll over but I am not findsing anything that works.. help!

[vicky_]

Instead of using FILTER(Table), you should use the DATESINPERIOD or PARALLELPERIOD function, which can handle the year roll-overs.