Visualization Title - Show Previous Month in mmm format

[jerryrou125]

Hi - 

I created the following measure to dislay on the title of my visualization:

Title-Visualization01 = 

"01/2023 to "&

&"/2023 Actual Spend vs. Target Spend"

Result:

01/2023 to 10/2023 Actual Spend vs. Target Spend

I would like the measure to display the following:

Jan 2023 to Oct 2023 Actual Spend vs. Target Spend

How do I convert  

MONTH(EOMONTH(TODAY(),-1))

to display the Month (Oct) instead of 10 ?

Thanks - Jerry

[olgad · Accepted solution]

Hi, 

FORMAT(EOMONTH(TODAY(), -1), "mmm")