How to combine 2 expression to display Jul-Sep 21 ?

[admin11]

Hi All

Month last -3 =

FORMAT (

DATE ( MAX ( 'Date'[YEAR2] ), MONTH ( TODAY () ) - 3, DAY ( TODAY () ) ),

"mmm-yy")

Return :- Jul 21

Month last -1 =

FORMAT (

DATE ( MAX ( 'Date'[YEAR2] ), MONTH ( TODAY () ) - 1, DAY ( TODAY () ) ),

"mmm-yy")

Return :- Sep 21

May i know how to combine above 2 expression into 1 expression , so that it will display Jul-Sep 21 ?

Paul

[mahoneypat · Accepted solution]

Please try this expression instead.

MonthRange =
VAR startdate =
    EDATE ( TODAY (), - 3 )
VAR enddate =
    DATE ( MAX ( 'Date'[Year2] ), MONTH ( TODAY () ) - 1, 1 )
RETURN
    FORMAT ( startdate, "MMM" ) & "-"
        & FORMAT ( enddate, "MMM yy" )

Pat

[mahoneypat · Accepted solution]

Please try this expression instead.

MonthRange =
VAR startdate =
    EDATE ( TODAY (), - 3 )
VAR enddate =
    DATE ( MAX ( 'Date'[Year2] ), MONTH ( TODAY () ) - 1, 1 )
RETURN
    FORMAT ( startdate, "MMM" ) & "-"
        & FORMAT ( enddate, "MMM yy" )

Pat

[admin11]

@mahoneypat 

Thank you very much , it work . 

i try to do it for April till June 2021 , it does not work.

Qtr Ptrvious=
VAR startdate =
EDATE ( TODAY (), - 6 )
VAR enddate =
DATE ( MAX ( 'Date'[Year2] ), MONTH ( TODAY () ) - 1, 1 )
RETURN
FORMAT ( startdate, "MMM" ) & "-"
& FORMAT ( enddate, "MMM yy" )

may i know where go wrong ?

Paul

[mahoneypat · Accepted solution]

You need to change the enddate variable too

VAR enddate =
DATE ( MAX ( 'Date'[Year2] ), MONTH ( TODAY () ) - 4, 1 )

Pat