Dynamic filter for last 8 quarters

[Idyllic_Data_Geek]

How do I create a dynamic filter for last 8 quarters. I have data coming in as 2020 Q1, 2021 Q2 etc. And, the data type is Vwstring,

Thanks in advance!

[Prometheus · Accepted solution]

@Idyllic_Data_Geek Does the data tell you what quarter the data ends with?

[binuacs · Accepted solution]

@Idyllic_Data_Geek Find the last 8 quarters using the generate row tool then join the quarter with your file quarter field

[Idyllic_Data_Geek · Accepted solution]

@binuacs  I did the exact same thing but the join is not working. Because the Quarter end date is not a unique field. One quarter has multiple categories and prices. so this approach is not working out for me! Thank you for you response.

[Idyllic_Data_Geek]

@Prometheus  No. The data is coming in monthly and I'm finding the quarters using this formula 

DateTimeFormat([Date],'%Y Q') + ToString(Ceil(ToNumber(DateTimeFormat([Date],'%m'))/3))

which gives me the output as 2020 Q1,2020 Q2 and as such..

[binuacs · Accepted solution]

@Idyllic_Data_Geek @Would you be able to upload some data and expected result? That would be easy to come to a solution