Create calculated column that flags if row is linked to another table or not

[MaxItaly]

Hello everyone.

Let's say I have two tables: [TableOne] and [TableTwo].

These two tables are linked by the field Key (in both tables).

The relationship is: [TableOne] one to many [TableTwo].

Not all rows of TableOne are linked to TableTwo.

What I'd like to create is a calculated column in TableOne that is equal to 1 if the row has a relationship with TableTwo, and is equal to 2 otherwise.

Is it possible to achieve this in some way?

Thanks to everyone who may give me a hint about this!

[MFelix · Accepted solution]

Hi @MaxItaly,

In table 1 create the following column:

KEY_VALID = IF(LOOKUPVALUE(Table2[KEY];Table2[KEY];Table1[KEY]) > 0 ; 1 ; 2)

If you want you can change the 1 / 2 by OK / NOK.

Regards,

MFelix

[MaxItaly]

Many thanks, it works like a charm!   😄