Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Problem with LOOKUPVALUE not searching multiple columns

Am I right in saying that I cannot use the same Search_ColumnName twice when using the LOOKUPVALUE function? I have 4 columns in one table with values that match the Search_ColumnName values in an...
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

If you know that there will only be 1 row which matches then you could use

Teamowner =
SELECTCOLUMNS (
    FILTER (
        Owner,
        Owner[Team] IN { S3SSL[tags1], S3SSL[tags2], S3SSL[tags3], S3SSL[tags4] }
    ),
    Owner[Owner]
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you for the reply but unfortunately that didnt work.

     

    This is what I am trying to achieve

     

     

    • johnt75's avatar
      johnt75
      Icon for Super User rankSuper User
      3 years ago

      You need to filter out the blanks as well,

      Teamowner =
SELECTCOLUMNS (
    FILTER (
        Owner,
        Owner[Team]
            IN { S3SSL[tags1], S3SSL[tags2], S3SSL[tags3], S3SSL[tags4] }
                && NOT ISBLANK ( Owner[Team] )
    ),
    Owner[Owner]
)