Forum Discussion

JamesBurke's avatar
JamesBurke
Helper III
2 years ago
Solved

Last Month

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(...
Need Help
  • davidding's avatar
    davidding
    2 years ago

    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")
    )

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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