To Join Both Date set result in one Table

[Chetan007]

Date Set -1

Data Set - 2

Final Output

[ryan_mayu]

@Chetan007 

you can try this

1. make sure the column names in the different tables are the same.

2. append the tables

3. group by tables

pls see the attachment below

[Chetan007]

can i do with table view (dax language)

[ryan_mayu · Accepted solution]

@Chetan007 

you can try to create a dim group table

Table 2 = distinct(union(DISTINCT('Table (2)'[Group]),DISTINCT('Table'[Group])))

and create relationship with both tables

then create a measure

Measure = sum('Table (2)'[Value])+sum('Table'[Value])

pls see the atttachment below

[manvishah17]

Hi @Chetan007 ,
Yes, you can achieve this with DAX  

FinalOutput =
SUMMARIZE (
UNION (
SELECTCOLUMNS(Dataset1, "Group", Dataset1[Group], "Value", Dataset1[Value]),
SELECTCOLUMNS(Dataset2, "Group", Dataset2[Group], "Value", Dataset2[Value])
),
[Group],
"Value", SUM([Value])
)

• UNION: Combines the rows from both Dataset1 and Dataset2 (based on the Group and Value columns).
• SELECTCOLUMNS: Ensures that both datasets have the same structure.
• SUMMARIZE: Groups the data by Group and calculates the sum of the Value for each group.