Forum Discussion
Solved
Extract text after/before certain symbol
Hi all, How can i extract the text from each side of a symbol in DAX? I have tried to apply the following formula: =LEFT(B2;(FIND("/";B2;1)-1)) , which works in excel. However, when i use...
Rasmusrock you have to use the fourth (conditional) parameter of the FIND function - it is used when the text which has to be found is not found - you have data where the "/" is not contained.
Then will your formula work.
Regards.
Pavel
