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

     

davidding's avatar
davidding
Resolver I
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")
)