Forum Discussion
Justas4478
Post Prodigy
4 years agoFormat to include text string
Hello I have tried FORMAT dax function and it solve some of the problem I had. And I noticed that it should be able to include text string as text in the formating in additional to the date formating...
- 4 years ago
Found solution. There might be better way to write it but it works.
FORMAT(FIRSTDATE('Date'[Date]),("\w\\\e"" ""dd mmm"))Just need to add \ before every letter you want to display as text.
Justas4478
Post Prodigy
4 years agoFound solution. There might be better way to write it but it works.
FORMAT(FIRSTDATE('Date'[Date]),("\w\\\e"" ""dd mmm"))
Just need to add \ before every letter you want to display as text.