If statement with multiple search words

[SGLake]

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.

[vanessafvg]

@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

[SGLake]

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 vanessafvg@gmail.com 

[SGLake]

I'll need to modify the report so I'm not violating company policy. What's wierd is that I just took the couple columns and put them in Excel and had my pbix look at that file and it works correctly. Does that give you a clue?

[vanessafvg]

@SGLake to be honest, not really lol 🙂  but it possibly has something to do with the format of the data.    Have you tried doing a format trim and clean of the data first?

[SGLake]

Unfortunately yes, I've trimmed and cleansed the column.

[vanessafvg]

@SGLake the only way to figure it out really is to share it i am afraid

[SGLake · Accepted solution]

Well I found a work around. I created a duplicate column and it works!!