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.

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

I 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 . 🙂