cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SGLake
Frequent Visitor

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.

 

Capture.JPG

 

 

 

 

 

 

1 ACCEPTED SOLUTION

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

View solution in original post

8 REPLIES 8
vanessafvg
Super User
Super User

@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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




I changed it to all lower case and I'm still having the same issue.

@SGLake do you want to share your pbix? send to vanessafvg@gmail.com 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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?

@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?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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

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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.