Get values of a column based on the quarter and check if current Quarter or the previouse

[messi007]

Dear Alteryx Community,

My case is to get the value of a column based on the quarter and check if current Quarter or the previous one

	Date	Value
1	2020 Q2	100
1	2020 Q3	50
2	2020 Q2	20
3	2020 Q3	30

Based on the quarter I want to extract Q which is Q3 in this case and Q-1 which is Q2 in this case

	T	T-1
1	50	100
2	0	20
3	30	0

However Image that for next year we will have 2021 Q1 and 2020 Q4 so T will be the information related to Q1 and T-1 will be information related to Q4

I have done this using a tile that will give -1 for small quarter and 1 for the bigger based on the last degite of the quarter but it will not be correct if we will compare Q4 2020 and Q1 2021

Best Regards,

[atcodedog05]

Hi @messi007 

I dont know how feasible this is. But it should give you some idea.

Here is a workflow for the task.

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[messi007 · Accepted solution]

@atcodedog05,

Thanks for the quick reply 🙂 I really appreciate your help

It helps but don't solve the problem as you are falling manually the Quarter : IIF(Right([Date], 1)="3",[T-1], [T]) next quarter will be 4 and it will not work.

Below How I have done it using a sort and multi row formula 🙂

Best Regards,