Forum Discussion
searching text for " symbol
I'm trying to write a dax formula that searches a product description text for the " symbol which indicates inches. My formula below doesn't work because powerbi is confused because " is used to call...
Hey Anonymous ,
Any of the Dax function for string matching wont work for this special character " ,you have two options either do it in the query editor by adding a conditional column or replace the special character " with '
If your problem is solved then please accept this as a solution
Thank you
Anonymous
Agree with Ajinkya369 , the easiest way is just replace " with other symbols.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.