Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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")
)
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")
)
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
User | Count |
---|---|
134 | |
73 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |