Forum Discussion
Post PatronJoin more than one columns
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]).
Super UserHello! 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.
Post PatronHi 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]).
- ak77
This was perfect solution i was looking for . Thanks a lot audreygerred
- audreygerred
You're very welcome!