No Relation Between Table

[Boveitj]

Hey Guys,

Simple Question for you, I have two tables one for Badge IDs and Another for Persons Name. I need to know how to make it when there is no relation that it will show up as "Invalid Badge ID" in tables, graphs, etc since this is user enter data. 

Example:

Table 1            Table 2

IDs                   Names

123                  Joe

452                  Mike

632                  Emily

123 = Joe

124 = Invalid Badge ID

[v-qiuyu-msft · Accepted solution]

Hi @Boveitj,

Assume there is a relationship between Table 1 and Table 2 based on IDs, then you can create a Calculated column like below:

Column1= IF(IsBlank(Related(Table 2[Names])),"Invalid Badge ID",Related(Table 2[Names]))

Best Regards,
Qiuyun Yu

[cartman21]

Could you not create an if function? If values match those in table a, return name, else return 0/invalid (in the case there is no match) ?