Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
Is there a way of joinning 2 columns from different tables, but related? I'd like to concatenate prodCode from Tab Sales with product from Tab Products.
Can you help?
Thanks in advance
Pedro
Solved! Go to Solution.
If they are related through a one-to-many connection (say table A annd table B), go to the B table and add a new column:
Concatenate = 'B table'[column1] && related(A table[column2])
Since Product contains 1 Value and Sales Contains Multiple Values therefore Reference Column will be created on Many Side because it will return 1 value from product. In this case you should create column in Sales Table rather than in Product Table.
Rule of thumb, reference column will always create on Many Side
Proud to be a Super User!
If they are related through a one-to-many connection (say table A annd table B), go to the B table and add a new column:
Concatenate = 'B table'[column1] && related(A table[column2])
Create a reference column in your table of 2nd table using
Reference Column = RELATED (Base Column)
add new column by using Concatenate function thru DAX
https://docs.microsoft.com/en-us/dax/concatenate-function-dax
Proud to be a Super User!
Hey @FarhanAhmed
I've tried to add that column, on the products table, cose in sales table i only have product code, and i want to see the name of the products and i couldn't because it "asks" me the column name....not a table and column name, you know?
Am i doing something wrong? (dum question)
Since Product contains 1 Value and Sales Contains Multiple Values therefore Reference Column will be created on Many Side because it will return 1 value from product. In this case you should create column in Sales Table rather than in Product Table.
Rule of thumb, reference column will always create on Many Side
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |