Previous quarter sales

[Lucky1]

Hi

In my data i have dec2022 data and march 2023 data.

I have used below formula to get current quarter data i.e march 2023 data .it is working fine. but i want to create one more kpi to show previous quarter data i.e 2022 dec data  how to do that.

currentquarter: =Count({<Date1 = {">=$(=Date(Quarterstart(max(Date1)),'DD-MM-YYYY'))<=$(=date(max(Date1),'DD-MM-YYYY'))"}>}Item_Id)

[CezarioAbrantes]

Hi,

You can do something like that:

=Count({<Date1 = {">=$(=Date(AddMonths(Quarterstart(max(Date1)),-3),'DD-MM-YYYY'))<=$(=date(AddMonths(max(Date1),-3),'DD-MM-YYYY'))"}>}Item_Id)

Regards

Cezário