Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create Measure for Last Completed Month

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!
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    You can try

    Last completed month = FORMAT( EOMONTH( TODAY(), 1), "YYYYMM")
johnt75's avatar
johnt75
Super User
3 years ago

You can try

Last completed month = FORMAT( EOMONTH( TODAY(), 1), "YYYYMM")
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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!