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 ( ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    try this

ppm1's avatar
ppm1
Solution Sage
2 years ago

Please try this approach instead.

 

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

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

    • Ahmedx's avatar
      Ahmedx
      Super User
      2 years ago

      try this