I need to create a measure in Power BI which counts clients on filtering conditions.

Is it possible to create filtering on future months? I need to count clients which agreement closing date is not future months, for example matrix table shows date in columns (it is other date, not closing) and clients number, so clients in 2024 Feb should be filtered that closing date would be before 2024 March and 2024 April, clients in 2024 March should be filtered so that closing date is before 2024 April and so on.

Max Date is always todays date, because I update my query daily.

It looks something like this:

Thanks in advance!