Forum Discussion
Post PatronJoin more than one columns
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
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]).
5 Replies
- audreygerred
Super User
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.
ak77Hi 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
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]).