Replace blank where no match

[Anonymous]

Hi,

I think this should be something simple that I am completly overlooking here so appolgoies if its an easy option but I cannot find it for the life of me.

Anyway, I have two tables, both with UserID. Table 1 contains records without a corresponding match in Table 2 between the relationship.

Rather than just show blanks, can I have this say like 'Unknown user' or something? 

I cannot change the data source to include the records.

I figure I can do it via some method of mulitle merges with a join and an anti join then replace nulls with my text then merge it all back together but this seems overly convulted.

Cheers,

Scott

[V-lianl-msft · Accepted solution]

You could create a new column like below:

Column = IF(
      SUMX(Table2,
           FIND(
                Table2[Userid],
                Table1[Userid]
                ,,0
               )
          ) > 0,
      "Yes",
      "No"
     )

[amitchandak]

@Anonymous , if you do not want to create a new table or column, I doubt that is possible.

[Anonymous]

Hi, thanks for the follow up 🙂

No simple function I am just missing then? I guess a new table it is..