Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
@Anonymous
It works with me
See the attached file
@Anonymous
It works with me
See the attached file
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |