Last Month

[JamesBurke]

Hi All ,

Date 2 Month = IF('Date'[Mth & Yr] = MONTH(TODAY()) -1, "Last Month", FORMAT('Date'[Mth & Yr], "MM-DD-YYYY"))

For Some reason is not showing the Last Month Option

Date 2 = IF('Date'[Date] = TODAY() -1 , "Yesterday", FORMAT('Date'[Date], "MMm DD YYYY"))

However this works for yesterday and gives me the option 

Any Help Would be appericated 🙂

Thanks, James.

[davidding · Accepted solution]

assuming the value in 'Date' [Mth & Yr] is always the beginning of the month e.g. "03-01-2024", this formular should work.

Date 2 Month =
IF(
'Date'[Mth & Yr] = DATE(YEAR(TODAY()),MONTH(TODAY())-1,1),
"Last Month",
FORMAT('Date'[Mth & Yr], "MM-DD-YYYY")
)

[chiru_kudupudi]

Please try the below formula

Date 2 Month = IF(
YEAR(Date[Date]) = YEAR(TODAY()) &&
MONTH(Date[Date]) = MONTH(TODAY()) - 1,
"Last Month",
FORMAT(Date[Date], "MM-DD-YYYY")
)

Regards,
Chiranjeevi Kudupudi