Forum Discussion
chadnelson
Helper I
Helper IDAX Help: Find partial match in another column to create a new column
I have two columns that look like the first two columns below (Ticket Creator & Group Members). I would like to create a third column (Member?) based on whether the ticket creator is a member of the ...
and try this cod in DAX
Ahmedx
Super User
Super Usersee my video
(x)=> if List.Count(List.Select({x[Group Members]}, (y)=>List.ContainsAny({y},{x[Ticket Creator]},Text.Contains )))=1 then "Member" else "Non-Member"