Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a visual as shown below. I am attempting to use advanced filtering to get rid of any invoices with the prefix of INMAR and DS. As one can see, it does not seem to be filtering out the INMAR invoices (it is not filtering out DS invoices either but I couldnt include them both on this screen shot). I have used Advanced filtering with sucess before, I cannot seem to figure out why it is not working.
Thanks in advance!
Solved! Go to Solution.
Hey @tstackhouse
You need to switch the OR to AND. OR won't filter out either because INMAR does not start with DS and DS does not start with INMAR. Kind of confusing...
Hope this helps,
Parker
Hey @tstackhouse
You need to switch the OR to AND. OR won't filter out either because INMAR does not start with DS and DS does not start with INMAR. Kind of confusing...
Hope this helps,
Parker
That is a little confusing. But thank you I will keep this in mind!
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |