Custom Column that calculates if a value from another table is present in a specific column

[octalllink]

I'm trying to create a custom column in the Account table that will lookup values in the RemoveSpecialChar table and return a value in the row if any of the values is present.

I got this from another solution: https://www.youtube.com/watch?v=9sKeZbfzBTk and now I'm trying to adopt it for my use but I'm running into issues.

This is my adoption:

= Table.AddColumn(Account1, "AccountNameValidate", IF (
    SUMX (RemoveSpecialChar, FIND (RemoveSpecialChar[FromValue__c], Account[Name],, 0 ) ) "insertgreaterthansymbol" 0,
    "Special",
    "")

[octalllink · Accepted solution]

I managed to get this working, the syntax was just wrong.

QualityCheck =

IF (

    SUMX ( RemoveSpecialChar, FIND ( RemoveSpecialChar[FromValue__c], Account[Name],, 0 ) ) > 0,

    "Special",

    ""

)

This is the result:

[bhanu_gautam]

@octalllink , Try using below given m-code in accounts table and go to create custom column

let
RemoveSpecialCharList = RemoveSpecialChar[FromValue__c],
CustomColumn = Table.AddColumn(Account, "AccountNameValidate", each if List.ContainsAny(Text.ToList([Name]), RemoveSpecialCharList) then "Special" else "")
in
CustomColumn

[octalllink]

Hi bhanu_gautam, thanks for the response but this is the outcome if I do that: