Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Format date to text full word

Lets say I have 2022/08/23, I want it to become August 23 in a measure, how would I do this? It would have to work with months that are not the same length so september or may.
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Try:
    Let's say the date comes from Table[Date].

    Text Date = 
FORMAT(MAX(Table[Date]), "MMMMM") & " " & DAY(MAX(Table[Date])
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Try:
Let's say the date comes from Table[Date].

Text Date = 
FORMAT(MAX(Table[Date]), "MMMMM") & " " & DAY(MAX(Table[Date])