DATEADD -6 Months Measure

[armchairexpert]

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? 

I am looking for something like the one below but this does not work.

STARTOFMONTH(DATEADD(TODAY(), -6, MONTH))

Thanks.

[Greg_Deckler · Accepted solution]

@armchairexpert Try:

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

[armchairexpert]

Hi @Greg_Deckler ,

Yes, it worked. Thank you very much.