topic Date from the 1st of month 3 months ago in DAX Commands and Tips

Date from the 1st of month 3 months ago

JamieH — Wed, 13 Oct 2021 10:50:54 GMT

I have a date table and would like to have a "Y"/"N" column in there that indicates if the DATE was within the last 3 calendar months, starting from the 1st of the month.

For example, where today is October 13, I would like every day from July 1st to today to have a "Y" with every other date being a "N".

Can someone please advise?

Thank you

Re: Date from the 1st of month 3 months ago

Greg_Deckler — Wed, 13 Oct 2021 11:09:59 GMT

JamieH Try:

Column = VAR __Today = TODAY() VAR __ThreeMonthsAgo = EOMONTH(__Today,-3) VAR __ThreeMonthsAgoStart = DATE(YEAR(__ThreeMonthsAgo),MONTH(__ThreeMonthsAgo),1) RETURN IF([Date] >= __ThreeMonthsAgoStart,"Y","N")

Re: Date from the 1st of month 3 months ago

JamieH — Wed, 13 Oct 2021 11:34:51 GMT

Thats great. Thanks Greg