Forum Discussion
agd50
2 years agoHelper V
Dynamic Month text - DAX
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
try this