Forum Discussion
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.
Try:
Let's say the date comes from Table[Date].Text Date = FORMAT(MAX(Table[Date]), "MMMMM") & " " & DAY(MAX(Table[Date])
1 Reply
PaulDBrownCommunity Champion
Try:
Let's say the date comes from Table[Date].Text Date = FORMAT(MAX(Table[Date]), "MMMMM") & " " & DAY(MAX(Table[Date])