Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Hi @muggydaniel ,
Please try the Text.Contains() function.
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.