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]

        )

    )

    )

amani1980's avatar
amani1980
Frequent Visitor
1 year ago

Hi,

 

Thanks for replying!

 

I want to do something similar not quite the same - I don't want to combine all columns from both tables. Just the Country and Ticket columns from the 30-40 colunms there is in each one of the tables. I showed just the two columns in the screenshot for sake of simplicity.