Summarize table

Hi Kristofferaabo,

To create a new table, in dax, you can use summarize(), selectcolumns(), addcolumns().

To achieve distinct values in column A oin the calculate table, you can use summarize function like pattern below:

calculate table =
UNION (
    SUMMARIZE (
        old_table1,
        old_table1[column_need_to_be_distinct],
        "column1", SUM ( old_table1[column1] )
    ),
    SUMMARIZE (
        old_table2,
        old_table2[column_need_to_de_distinct],
        "column2", SUM ( old_table2[column2] )
    )
)

Also refer to DAX summarize here:https://msdn.microsoft.com/en-us/query-bi/dax/summarize-function-dax

Regards,

Jimmy Tao