I want to show last month from today. I have this measure but instead of February it's showing January. Any idea? LastMonth = FORMAT(MONTH(TODAY()-1), "MMMM") <-- this shows JanuaryLastMonth = FORMAT(MONTH(EOMONTH(TODAY(),-1)), "MMMM") <-- this shows JanuaryLastMonth = MONTH(EOMONTH(TODAY(),-1)) <--- this shows '2' or Feb. Thanks

diskovered try this Last Month = FORMAT( EOMONTH( TODAY(), -1 ), "MMMM" )

Forum Discussion

Helper III

7 years ago

Solved

I want to show last month from today. I have this measure but instead of February it's showing January. Any idea?

LastMonth = FORMAT(MONTH(TODAY()-1), "MMMM") <-- this shows January

LastMonth = FORMAT(MONTH(EOMONTH(TODAY(),-1)), "MMMM") <-- this shows January

LastMonth = MONTH(EOMONTH(TODAY(),-1)) <--- this shows '2' or Feb.

Thanks

parry2k
7 years ago
diskovered try this

Last Month = FORMAT( EOMONTH( TODAY(), -1 ), "MMMM" )
parry2k
7 years ago
diskovered yup

Last Month = FORMAT( EOMONTH( TODAY(), -1 ), "MMMM, yyyy" )