Latest Enterprise DNA Initiatives


Creating a new table from multiple other tables with similar data

Hi all,

I’m exploring something like what the UNION function does with more than two tables. My report has multiple data tables wherein four of them have an “Agency” column that contains similar data. I want to take the unique values from all four tables and put them in a new table with a single “Agency” column. Does anyone know how I can do this?

You can try:

    New Table = 
    DISTINCT(
    UNION( 
        DISTINCT(Table1[Agency]), 
        DISTINCT(Table2[Agency]), 
        DISTINCT(Table3[Agency])
        )
    )

Enterprise%20DNA%20Expert%20-%20Small

Yep UNION is the way to go here.

Check out this example here to learn a bit more about how UNION can work.