cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
Super User

Hi @Paulyeo11 ,

```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 🙂

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

 Also happily accepting Kudos 🙂

 Feel free to connect with me on LinkedIn!

 #proudtobeasuperuser

2 REPLIES 2
Super User

Hi @Paulyeo11 ,

```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 🙂

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

 Also happily accepting Kudos 🙂

 Feel free to connect with me on LinkedIn!

 #proudtobeasuperuser

Impactful Individual

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

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors