Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
muggydaniel
New Member

Custom Collumn searching for Duplicate Values

Hi all 

 

I have table collumn where it contains values such as: 

 

482932983

Ryan by themselves and as the main goalkeeper

482932984

Tim and John by themselves and as the main strikers

482932985

Kepa and Ronaldo by themselves and as main players

 

I am looking to grab instances where there is 2x players within the statements

 

1 certainty is that there always exists 2x "and" instances if that is true.  I am not sure how to get a custom collumn where it picks up the 2x "and" instead of just 1

 

Anyone have any ideas?

1 REPLY 1
v-stephen-msft
Community Support
Community Support

Hi @muggydaniel ,

 

Please try the Text.Contains() function.

vstephenmsft_0-1677132660449.png

vstephenmsft_1-1677132666566.png

Text.Contains - PowerQuery M | Microsoft Learn 

                                                                                                                                                        

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors