cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SGLake Frequent Visitor
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

Accepted Solutions
SGLake Frequent Visitor
Frequent Visitor

Re: If statement with multiple search words

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

8 REPLIES 8
vanessafvg Super Contributor
Super Contributor

Re: If statement with multiple search words

@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!
SGLake Frequent Visitor
Frequent Visitor

Re: If statement with multiple search words

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

vanessafvg Super Contributor
Super Contributor

Re: If statement with multiple search words

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


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
SGLake Frequent Visitor
Frequent Visitor

Re: If statement with multiple search words

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 Super Contributor
Super Contributor

Re: If statement with multiple search words

@SGLake to be honest, not really lol Smiley Happy  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?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Highlighted
SGLake Frequent Visitor
Frequent Visitor

Re: If statement with multiple search words

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

vanessafvg Super Contributor
Super Contributor

Re: If statement with multiple search words

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


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
SGLake Frequent Visitor
Frequent Visitor

Re: If statement with multiple search words

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 109 members 1,548 guests
Please welcome our newest community members: