Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
5 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...
Need Help
  • Justas4478's avatar
    Justas4478
    5 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.
v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
5 years ago

Thanks for sharing😀