Forum Discussion

Chetan007's avatar
Chetan007
Frequent Visitor
1 year ago
Solved

To Join Both Date set result in one Table

Date Set -1 Data Set - 2 Final Output
Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    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
Chetan007's avatar
Chetan007
Frequent Visitor
1 year ago

can i do with table view (dax language)

  • manvishah17's avatar
    manvishah17
    Icon for Solution Supplier rankSolution Supplier
    1 year ago

    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. 



     

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    1 year ago

    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