cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Curious44
New Member

Joining tables using calculated column

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.

 

1 ACCEPTED SOLUTION
Phil_Seamark
Microsoft
Microsoft

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

1 REPLY 1
Phil_Seamark
Microsoft
Microsoft

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.