Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

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

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
 
Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    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's avatar
    mahoneypat
    4 years ago

    You need to change the enddate variable too

     

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

     

    Pat

3 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    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's avatar
      admin11
      Icon for Memorable Member rankMemorable Member
      4 years ago

      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's avatar
        mahoneypat
        Icon for Microsoft Employee rankMicrosoft Employee
        4 years ago

        You need to change the enddate variable too

         

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

         

        Pat