date filter

[Ns7703]

I want to add filtering in such way that , If I am choosing  march 2024 month then I will get the summed up data till february 2024 

[BrunPierre · Accepted solution]

Something like this

=Sum({<Date={"<=$(=Date(AddMonths(Max(Date), -1), 'YYYY-MM'))"}>} Sales)