Forum Discussion

agd50's avatar
agd50
Helper V
2 years ago
Solved

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

3 Replies

  • ppm1's avatar
    ppm1
    Solution Sage

    Please try this approach instead.

     

    ThisMonth = FORMAT(TODAY(), "1 MMMM - \QQ yyyy")
     
    Pat
    • agd50's avatar
      agd50
      Helper V

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