Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Paulyeo11
Impactful Individual
Impactful Individual

How to make my expression display Q1-22 ?

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
1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

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/ 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

2 REPLIES 2
tackytechtom
Super User
Super User

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/ 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

@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  

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.