Forum Discussion

amani1980's avatar
amani1980
Frequent Visitor
1 year ago
Solved

Combine two columns...(Not Merge)

Hi,   I'm looking to combine data from two columns from different tables. Not merge. Each table has two columns country and event and I want to create a new table that contains both tables as shown...
  • FreemanZ's avatar
    FreemanZ
    1 year ago

    hi amani1980 ,

     

    try to write a calculated table like:

    table3=

    DISTINCT(

    UNION(

        SUMMARIZE(

            table1, 

            table1[country],

            table1[ticket]

        ),

        SUMMARIZE(

            table2, 

            table2[country],

            table2[ticket]

        )

    )

    )

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
1 year ago

hi amani1980 ,

 

try to write a calculated table like:

table3=

DISTINCT(

UNION(

    SUMMARIZE(

        table1, 

        table1[country],

        table1[ticket]

    ),

    SUMMARIZE(

        table2, 

        table2[country],

        table2[ticket]

    )

)

)