Forum Discussion
Add a Column in a table to another table
Hi, How to add a column "Week No." which is in 'Table A' to the columns in Table B
Anonymous
Ensure both Table A and Table B have a common column
Go to the Model view in Power BI, and drag the common column from Table A to Table B to create a relationship.
Create a new column in Table B
Week No. = RELATED('Table A'[Week No.])💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
You can achieve this via Power Query
Go to Power Query Editor -> PQE Home -> Merge Queries -> Left join