How to make my expression display Q1-22 ?

[Paulyeo11]

Hi All

Below expression working fine  , it will return "Apr-Jun 22":-

Qtr Current =

VAR startdate =

EDATE ( TODAY (), - 0 )

VAR enddate =

DATE ( MAX ( 'DATE'[Year2] ), MONTH ( TODAY () ) +2 , 1 )

RETURN

FORMAT ( startdate, "MMM" ) & "-"

& FORMAT ( enddate, "MMM yy" )

May i know how to make it display Q2-22 ?

Paul

[tackytechtom · Accepted solution]

Hi @Paulyeo11 ,

How about this:

Qtr Current =
VAR startdate =
EDATE ( TODAY (), - 0 )
VAR enddate =
DATE ( MAX ( 'DATE'[Year2] ), MONTH ( TODAY () ) +2 , 1 )
RETURN
"Q" & FORMAT(startdate, "q") & "-" &  FORMAT(startdate, "yy") 

Let me know if this works 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/ 

[Paulyeo11]

@tackytechtom 

Your expression working e fine ,

thank you very much.

my next question is , when i the month of may and june , will your expression still display Q2-22 ?

Paul