Show only this financial Qtr and previous two quarters only on a matrix

[Anonymous]

Hi community,

In the following matrix layout, how can I show this fiancial Qtr and previous two quarters only. For example, at present show only FY20/21-Q3, Q4 and FY21/22 Q1.

FY year starts on July 1.

Quarters & FY year comes from date table.

Thanks

[amitchandak]

@Anonymous , you can create a flag like this in your date table and use that

qtr Type =
Var _lastq = date(year(today()), month(Today())-6,1)
Switch( True(),
[start qtr]<=Today() && [end qtr]>=_lastq,"Last 3 qtr" ,
[qtr Name]
)

[Anonymous]

@amitchandak thanks, I want the quarters to list under FY years matrix columns. The above logic doesn't work with that.

[amitchandak · Accepted solution]

@Anonymous , FY Qtr from July is FY rename. StartdateofQtr will give you that

Jan, Apr, Jul and Oct are standatd Qtr

Start Year = STARTOFQUARTER('Date'[Date])

END Year = ENDOFQUARTER('Date'[Date])

or

Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441

Qtr Start Date = DATEADD(STARTOFYEAR('Date'[Date],"7/30"),QUOTIENT(DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH),3)*3,MONTH)