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.
@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
Did I answer your question? Mark my post as a solution. Proud a to be a Datanaut!
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?