Month Format

[Anonymous]

I am trying to add the month into the report I am creating. I made a measure and have displayed it as a card. This is the formula for my measure. Report Month = FORMAT(MONTH(TODAY()),"mmmm"). However, the card is displaying January and not May.

[TomMartens · Accepted solution]

Hey,

use this formula:

Current Month Name = FORMAT(TODAY(),"mmmm")

Format needs a real date, using MONTH is returning just an integer.

Regards

Tom 

[Phil_Seamark]

And a date of 5 is Thursday the 4th of January, 1900, which is why it was returning Jan

[Phil_Seamark]

Hi @Anonymous

Please try this instead. 

Report Month = FORMAT(TODAY(),"MMMM")