Measure for my title to automatically use last month name in the sentence

[RogerSteinberg]

Hi,

For my report, i need my title to show last month of today's date.

For example, if we are Oct. 1st 2020, my report title should be

2020-Sep

I have a date table where my lastdate is TODAY()

How can I create a measure for this?

[themistoklis · Accepted solution]

@RogerSteinberg 

Could you please try the following:

Measure = DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))

Measure = FORMAT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY())), "YYYY-MM")