Forum Discussion
If statement with multiple search words
I've tried creating this with the conditional column but there seems to be a bug when analyzing my text. In my "Other" output, text is showing up than contains the word "funding" so it should be the "Funding" output - but it's not. I've cleansed my text and made sure there isn't any leading spaces. Am I doing something wrong or is there a better way to go about it? Oh yea, when I filter the text containing the word "funding" that works correctly so I'm thinking there's a bug with the conditional column function.
Well I found a work around. I created a duplicate column and it works!!
8 Replies
- vanessafvg
Community Champion
SGLake powerquery / m is case sensitive, so if its not in the same case as your condition it wont pick it up, try changing it all to the same case first usung add column / format / upper or lower case
I changed it to all lower case and I'm still having the same issue.
- vanessafvg
SGLake do you want to share your pbix? send to [email protected]
