Forum Discussion
No Relation Between Table
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
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
2 Replies
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) ?
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
