Forum Discussion

12scml's avatar
12scml
Resolver I
9 years ago
Solved

Updating List

Hi everyone! I am currently working with three tables that I need to combine into one. In each table, I have a "Name" column. I would like to stack the names on top of one another to create on sup...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi 12scml,

     

    You can create a calculated table using below DAX formula:

    NewTable =
UNION (
    SELECTCOLUMNS ( Table1, "Name", Table1[Name] ),
    SELECTCOLUMNS ( Table2, "Name", Table2[Name] ),
    SELECTCOLUMNS ( Table3, "Name", Table3[Name] )
)

    It will update automatically when you refreshing the source tables (Table1, Table2, Table3).

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi 12scml,

 

You can create a calculated table using below DAX formula:

NewTable =
UNION (
    SELECTCOLUMNS ( Table1, "Name", Table1[Name] ),
    SELECTCOLUMNS ( Table2, "Name", Table2[Name] ),
    SELECTCOLUMNS ( Table3, "Name", Table3[Name] )
)

It will update automatically when you refreshing the source tables (Table1, Table2, Table3).

 

Best regards,
Yuliana Gu