Joining tables using calculated column

[Curious44]

I am trying to join two tables T1 and T2.

T1 has a calculated column which is concatentation of fields Type and Age.

T2 comes from excel and had the fields Type and Age concatentation performed in excel prior to loading.

When I try to join, get error where it believes relationship is many to many.

Can pull individual fields into Power BI and join back to T1 w/o issues.

Also spot checked the data and do not see any issues with T2 i.e. concatenated field is unique.

Any assistance would be appreciated.

[Phil_Seamark · Accepted solution]

Blanks and nulls can trip you up.  Every single value/row in the table on the 1 side of the 1:Many must be unique.   So if you can have blank values in this column and there are more than 1 row with a blank column, you will fail this referential integrity test.