Forum Discussion
contains string in power query
Hi Is it possible to do something similar to the below in power query, i currently have this measure as a calculated column in my table: IF ( CONTAINSSTRING ('Table'[Entry], "Attend" ),"At...
The M code for that would be text.Contains (I'll link below) if you're wanting to go this route.
A more user friendly way to do it would be to add a conditional column and just fill out the UI it opens!
https://learn.microsoft.com/en-us/powerquery-m/text-contains
The M code for that would be text.Contains (I'll link below) if you're wanting to go this route.
A more user friendly way to do it would be to add a conditional column and just fill out the UI it opens!
https://learn.microsoft.com/en-us/powerquery-m/text-contains