cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jenelrosales Regular Visitor
Regular Visitor

Filtering Column with Text which contains Parentheses

Hello everyone.

 

I am working on a data which I need to filter based on a text, which basically has a parenthesis in it. 

 

Like Dogs (not Cats).

 

So if I write my filter like this:

 

FILTER(Animals, Animals[Type] = "Dogs (not Cats)"),

 

the parentheses, which is part of the text is ignored and I end up getting null values.

 

How do I write the filter so that the parentheses will be included?

 

Thanks!
 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Filtering Column with Text which contains Parentheses

@jenelrosales

 

It works with me  Smiley Surprised

 

See the attached file

1 REPLY 1
Super User
Super User

Re: Filtering Column with Text which contains Parentheses

@jenelrosales

 

It works with me  Smiley Surprised

 

See the attached file