Forum Discussion

Sonne's avatar
Sonne
Icon for Helper II rankHelper II
6 years ago
Solved

merge 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 ha...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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's avatar
    Geradav
    Icon for Responsive Resident rankResponsive Resident
    6 years ago

    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.