Date of report

[Anonymous]

Hi all, I want to create a measure which displays last month in word format not number. Any help would be appreciated. e.g. the measure should return 'July' if it was used today.

[amitchandak · Accepted solution]

@Anonymous ,

format(eomonth(today(),-1),"MMMM")

[mahoneypat]

You can make a measure with this expression

This Month = FORMAT(TODAY(), "MMMM")

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

@mahoneypat thank you for your response, however I am trying to return last month, not this month. Any idea how I could go about this.