Creating a new table from multiple other tables with similar data

DAX DAX Calculations
1

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?

2

You can try:

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

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

3

Yep UNION is the way to go here.

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