Show only Previous Month name

[Poma]

Hi,
I am trying to create a dynamic title to show the previous month name:

Title_Total in Previous Month = "Total in "& FORMAT( MONTH(TODAY()) -1, "MMMM")

Right now we are in August so I wanted it to show me July but it is showing me January.

Can someone help me to solve this issue pls.

[Poma]

I cleaned the cached and its correct now 🙂 thanks

[Jihwan_Kim · Accepted solution]

Please try the below.

Title_Total in Previous Month =

"Total in "&

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

[Poma]

Hi @Jihwan_Kim 
Thank you for your responce. It is wierd becouse I 3 card, with your dax 2 of them are showing the correct monthname "July" but one of them is still showing January

😞