Forum Discussion
How to Join tables and Add column using DAX(Edit Query)
Providing you have a relationship, just add a column on Table A, the paste in the following
Degree = RELATED('Table B'[Degree])Anonymous , one is merge table in edit query
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Dax way
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
New column in Table A
maxx(filter('Table B', 'Table A'[ID] ='Table B'[User ID]),'Table B'[Degree])
Hello Anonymous
Power Query way: Merge Queries
With Table A selected > Home > Merge Queries:
Select Table B in the second table and select the common column (ID in this case):
Under Join Kind, select Left Outer. Click Ok
Expand the table > Select the required column from Table B
Click Ok.
Output:
For more details, you may refer to the following:
https://www.vivran.in/post/bi-simplified-webinar-1-p4-merge-queries