Create one summarized table from two tables.

[Anonymous]

I have tables like this:

Table 1

Custom	Act Qty	Act Rev
11223344	323	221
22334455	2442	2223
111222333	453	214
22334455	4545	454

Table 2

Custom	Plan Qty	Plan Rev
AABBCCDD	2422	2324
111222333	453	214
11223344	122	229
22334455	4545	454

I would like to summarize the two tables seperately. And then merge the two tables with Custom being the common column resulting in 5 columns.

[Ashish_Mathur]

Hi,

I believe that the ideal structure to have is where you have a single table.  Rename the second and third columns to Qty and Rev.  In both tables insert a column (titled as Nature) with Actual and Plan entries in that column.  In the Query Editor, append the two tables.

[Anonymous]

By adding 

custom = distinct(union(distinct(Table[Custom]),distinct(Table[Custom])))

I am seeing one custom column. In the same dimension/table, I wish to see the ACT QTY, ACT  Volume, Plan QTY, Plan Volume.

[amitchandak]

@Anonymous , Create a common dimension custom and join with both tables

custom = distinct(union(distinct(Table[Custom]),distinct(Table[Custom])))

use that to analyze. You can individual measure from both tables and combine one as per need

m1= Sum(Table1[Act Qty])

M2 = sum(Table2[Plan Qty])

M3 = [m1] +[m2]

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda

[Anonymous]

custom = distinct(union(distinct(Table[Custom]),distinct(Table[Custom])))

I am seeing one custom column. In the same dimension/table, I wish to see the ACT QTY, ACT  Volume, Plan QTY, Plan Volume.