Forum Discussion

Frequent Visitor

10 years ago

Solved

creating table from multiple other tables

I have a report with multiple data tables. Four of them have a column that is named agency with similar data. I want to take the distinct values from all four tables and create a new table with a sin...

samdthompson
10 years ago
Hi, welcome to the community, try this: Go to the modelling tab on the ribbon and click create new table. In the formula bar use the DAX expression
=
SUMMARIZE (
    UNION (
        ALL ( Table1[UniqueValue] ),
        ALL ( Table2[UniqueValue] ),
        ALL ( Table3[UniqueValue] ),
        ALL ( Table4[UniqueValue] )
    ),
    [UniqueValue]
)

//If this solves your question please mark as such

samdthompson

Memorable Member

10 years ago

Hi, welcome to the community, try this: Go to the modelling tab on the ribbon and click create new table. In the formula bar use the DAX expression

=
SUMMARIZE (
    UNION (
        ALL ( Table1[UniqueValue] ),
        ALL ( Table2[UniqueValue] ),
        ALL ( Table3[UniqueValue] ),
        ALL ( Table4[UniqueValue] )
    ),
    [UniqueValue]
)

//If this solves your question please mark as such

Anonymous
Not applicable
8 years ago
=
SUMMARIZE (
    UNION (
        ALL ( Table1[UniqueValue] ),
        ALL ( Table2[UniqueValue] ),
        ALL ( Table3[UniqueValue] ),
        ALL ( Table4[UniqueValue] )
    ),
    [UniqueValue]
)

What is this unique value line at the end supposed to be?