Forum Discussion
Helper IImerge columns from different table into 1 table
Hello,
I dont find the formula for my problem . hopefully somebody can help me.
i have different tables with different fields, but 3 columns are always the same . this 3 columns i want to have in a addional table ( distinct).
Try like
distinct(
union
(
selectcolumns(Table1,"UPI",Table1[UPI],"ID",Table1[ID],"Personalnumber",Table1[Personalnumber]),
selectcolumns(Table2,"UPI",Table2[UPI],"ID",Table2[ID],"Personalnumber",Table2[Personalnumber]),
selectcolumns(Table3,"UPI",Table3[UPI],"ID",Table3[ID],"Personalnumber",Table3[Personalnumber])
)
)You can also use summarize in place of select columns, Small diff in syntax.
4 Replies
- amitchandak
Super User
Try like
distinct(
union
(
selectcolumns(Table1,"UPI",Table1[UPI],"ID",Table1[ID],"Personalnumber",Table1[Personalnumber]),
selectcolumns(Table2,"UPI",Table2[UPI],"ID",Table2[ID],"Personalnumber",Table2[Personalnumber]),
selectcolumns(Table3,"UPI",Table3[UPI],"ID",Table3[ID],"Personalnumber",Table3[Personalnumber])
)
)You can also use summarize in place of select columns, Small diff in syntax.
- Geradav
Responsive Resident
Sonne What amitchandak is proposing is a DAX measure. Just precision in case you are not entirely familiar.
So now you have a solution in both languages M (Power Query) and DAX.
Your choice.
- Geradav
HI Sonne ,
You can achieve that in the Power Query Editor with the tools available in the Ribbon.
You can use the Append Queries function in te Combine group of the Home tab.
Then you Choose Columns (Manage Columns group in the Home tab) you want to keep and Remove Duplicates (Click on Remove Rows in the Reduce Rows group of the Home tab)
Let us know if that works for you.
Regards
David
SonneI tried the DAX solution and it is working fantastic. Exactly what I was looking for. I had the Distinct and Union command in my mind and tried, but the selectcolumns i didn't think off.
Thanks very much for the fast response. It saved my day . 🙂
