Show last 5 quarter (15 months) when i select any Quarter-Year from slicer

[Shak_Stoke]

Hi there, 

I have a finance data and want to show last 5 complate quarters months in Matrix Column when i select any Quarter-Year from slicers.

For example, I have two year data from Jan-2020 till Dec-2021. Now i have Quarter year slicer and when i select Q4-2021 my Matrix should show all previous 15 months-Year (From Sep-2021 till Jul-2020) for last 5 complete quarters i.e Q3-2021, Q2-2021,Q1-2021,Q4-2020,Q3-2020. 

Slicer
Q4-2021
Cureency	Sep-21	Aug-21	Jul-21	Jun-21	May-21	Apr-21	Mar-21	Feb-21	Jan-21	Dec-20	Nov-20	Oct-20	Sep-20	Aug-20	Jul-20
USD	1556	1564	456	4654	522	55	48	466	656	689	879	822	4669	456	4636

[CNENFRNL]

[Shak_Stoke]

Thanks a lot for your help. Really appreciate it. 

I need another favour related to this. Now i want to create two measures one for last 4 quarter and another for prior running 4 quarters.

I have craeted last 4 Qtr by using above logic and it worked but for prior runing it's not working 

For Last 4Qtr  e.g if we see above example and select Q4-2021 in our slicer then Last 4Qtr should show Q3-2021, Q2-2021, Q1-2021 and Q4-2020

I used below measure and it worked

Last 4Qtr =

CALCULATE(

    SUM( TXN[Qty] ),

    DATESINPERIOD( DATES[Date], MIN( DATES[Date] ) - 1, -4, QUARTER )

Now i want to create Prior runing 4 qtr total e.g if we see above example and select Q4-2021 in slicer then Prior 4 Qtr measure should show Q2-2021, Q1-2021, Q4-2020 and Q3-2020.

Can you please help with this?

[CNENFRNL · Accepted solution]

[Shak_Stoke]

Thanks for sharing this.  Apologies i think i wasn't clear in my previous post. We don't need running qtr But the requirement is we want to skip 2 qtr as in the above example 20221 is selected in slicer and table is showing  2021-Q4, 2021-Q3, 2021-Q2 and 2021-Q1 . However, we want to show 2021-Q3, 2021-Q2, 2021-Q1 and 2020-Q4.

Thanks