How to simulate my expression today is 1 May ?

[admin11]

Hi All

I have below expression , now return Mar 2021 , i like to know by tomorrow will is return Apr 2021 ? instead of waiting for tomorrow. it there a way to test ?

Month Previous =

FORMAT(DATE(YEAR(TODAY()),MONTH(TODAY())-2,DAY(TODAY())),"mmm-yyyy")

[v-kelly-msft · Accepted solution]

Hi  @admin11 ,

Create  a measure as below:

Measure = FORMAT(TODAY()+1,"mmm-yyyy")

And you will see:

Assume that today is Apr 30:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[admin11]

@v-kelly-msft 

Thank you , it work

Paul

[amitchandak]

@admin11 , Try like

Month Previous =
FORMAT(eomonth(TODAY(),-1),"mmm-yyyy")