Create Measure for Last Completed Month

[Anonymous]

Hello,

I would like to create a measure for the last completed month, formatted as such: YYYYMM. Is there an easy measure to accomplish this?

Thanks in advance!

[johnt75 · Accepted solution]

You can try

Last completed month = FORMAT( EOMONTH( TODAY(), 1), "YYYYMM")

[Anonymous]

Thanks for the reply. It did not seem to like that format. I updated it as follows: 

Last Completed Month = FORMAT(EOMONTH(TODAY(), -1), "YYYY/MM"). I should be able to make this work.

Thank you!