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.

Please try the below. Title_Total in Previous Month = "Total in "& FORMAT(EOMONTH(TODAY(),-1), "MMMM")

Forum Discussion

Frequent Visitor

5 years ago

Solved

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.

Jihwan_Kim
Super User
5 years ago
Please try the below.

Title_Total in Previous Month =
"Total in "&
FORMAT(EOMONTH(TODAY(),-1), "MMMM")
- Poma
  Frequent Visitor
  5 years ago
  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
  😞
Poma
Frequent Visitor
5 years ago
I cleaned the cached and its correct now 🙂 thanks