Forum Discussion
Solved
Power Query M - Conditional Column based on whether lookup column contains a list of items
I have used the Add Conditional Column process in M / Power Query, but would like to know if there is a way to condense this code to search for items in a list instead of using equals for all of the ...
Hi JRHans09 ,
Sounds like you need
List.Contains.Something like:if List.Contains( {"COM","DOM","LOC"}, [code-code]} then "DOM"
Hi JRHans09 ,
Sounds like you need List.Contains.Something like:
if List.Contains( {"COM","DOM","LOC"}, [code-code]} then "DOM"
