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")

2 Replies

  • 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!