Dynamic Month text - DAX

[agd50]

I want to show the text of a month ie January instead of the number. Here is what I have currently.

Title Page Sub Title text = 
 Var Year = INT ( YEAR ( TODAY () ) )
 Var Quarter = INT ( FORMAT(NOW (),
 "q" ) )
 Var Month = MONTH (TODAY () )

 Return
 
"1"&" "&Month-2 & " " & " " &"-"&" "&Month-3& "31" " " & Year

It shows 11 instead of November. How do I get it to show November instead? (Also an error message will appear due to the numbers next to month as I want to select the months)

TIA

[ppm1]

Please try this approach instead.

ThisMonth = FORMAT(TODAY(), "1 MMMM - \QQ yyyy")

Pat

[agd50]

Love it, only issue is that it won't let me add -1 after the return so I can change the month.

[Ahmedx · Accepted solution]

try this