Forum Discussion

jerryrou125's avatar
jerryrou125
Frequent Visitor
2 years ago
Solved

Visualization Title - Show Previous Month in mmm format

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
 
EOMONTH
Month Format

1 Reply

  • olgad's avatar
    olgad
    Resident Rockstar
    2 years ago

    Hi, 

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