Forum Discussion

Justas4478's avatar
Justas4478
Post Prodigy
4 years ago
Solved

Format 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...
  • Justas4478's avatar
    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.