Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Something like this
=Sum({<Date={"<=$(=Date(AddMonths(Max(Date), -1), 'YYYY-MM'))"}>} Sales)
Something like this
=Sum({<Date={"<=$(=Date(AddMonths(Max(Date), -1), 'YYYY-MM'))"}>} Sales)