Forum Discussion
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 that it can do. I did try to do it but it doesnt seem to work. Anyone know what I am writing incorrect?
I want the ABCD text string to apear as a text string in the card below infront of the date 30 Aug. in the dax documentation it tells to use this.
| ("ABC") | Display the string inside the double quotation marks (" "). |
https://docs.microsoft.com/en-us/dax/format-function-dax
Thank you.
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.
2 Replies
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.Thanks for sharing😀
