Join more than one columns

[ak77]

Hi team,

i need a help. i have 2 tables 

Table1:

Table 2

i need to join both tables based on 2 columns Sequence and client and place FootNote ID in the Table 1 for the matchinas combination as shown below . Can someone please help..how to use multiple column join condition? i have attached sample pbix for reference

https://drive.google.com/file/d/1-PG8XJx_rdEweLeRNjViqYAj7dTO0O8V/view?usp=sharing

[audreygerred]

Hello! Create a concatenated field in both tables (Sequence and Client - I usually do it with "_" in between the two fields, so it would look like 000_c1, 000.000_c1, etc) then, join on the new field which is your key.

[ak77]

Hi @audreygerred  , thanks

i tried by concatenated field in both tables and use them as common join column. 

but when i try to use columns of sheet1 table in calculated columns or measures of sheet2 table or viceversa.. it does not allow even though join is done... is it a normal behaviour?

[audreygerred · Accepted solution]

If you want FootNoteID to appear in Table 1, go into Table 1 and try to create a calculated column like:

FootNoteID = RELATED('Table2'[FootNoteID]). 

RELATED function (DAX) - DAX | Microsoft Learn

[ak77]

This was perfect solution i was looking for . Thanks a lot @audreygerred 

[audreygerred]

You're very welcome!