Forum Discussion

armchairexpert's avatar
armchairexpert
Icon for Helper III rankHelper III
3 years ago
Solved

DATEADD -6 Months Measure

Hi,   I need to create a measure to store the beginning of -6 months from today for comparrision. If it is 14th June 2023 today, then it should give me 1st of December 2022. Can someone please help...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    armchairexpert Try:

    Measure = 
  VAR __EOMonth = EOMONTH( TODAY(), -6 )
  VAR __Return = DATE( YEAR( __EOMonth ), MONTH( __EOMonth ), 1 )
RETURN
  __Return
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

armchairexpert Try:

Measure = 
  VAR __EOMonth = EOMONTH( TODAY(), -6 )
  VAR __Return = DATE( YEAR( __EOMonth ), MONTH( __EOMonth ), 1 )
RETURN
  __Return