Need to get previous quarter value for the selection quarter

[128718]

 Hi Team, 

My requirement is when I select Q4-2021 in filter I should get Q3-2021(measured value) in KPI object similarly when I select Q3-2021 I should get Q2-2021(measured value) in KPI object.

I have tried

count({<Date={">=$(=QuarterStart(Max(Date),-1))<=$(=QuarterEnd(Max(Date),-1))"}>} sales)  as my measure

but got 

Expected output:

Could you please help me to achieve the above requirement.

Thanks

[abhijitnalekar]

Hi @128718 ,

Please follow the below steps to get the required output.

1. Create  new dimension in the script as  Ceil(Month(SatrtDate)/3) as Quart

2. Create 2 variables as maxq with expression : =max(Quart) and PrevQ as expression  : =max(Quart)-1

3. write a expression in KPI as measure for current Quarter :  count({<Quart={"$(maxq)"}>}ID) and

prev Quarter as  count({<Qart={"$(PrevQ)"}>}ID)

Hope this helps you.

[abhijitnalekar · Accepted solution]

Hi @128718 ,

Please follow the below steps to get the required output.

1. Create  new dimension in the script as  Ceil(Month(SatrtDate)/3) as Quart

2. Create 2 variables as maxq with expression : =max(Quart) and PrevQ as expression  : =max(Quart)-1

3. write a expression in KPI as measure for current Quarter :  count({<Quart={"$(maxq)"}>}ID) and

prev Quarter as  count({<Qart={"$(PrevQ)"}>}ID)

Hope this helps you.