Forum Discussion
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('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.
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")
)
2 Replies
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")
)
