Forum Discussion

Gaizka's avatar
Gaizka
Regular Visitor
8 years ago
Solved

Sum from different tables based on other values

I have some tables with the same information:   Table 1, 2, 3...   Date     Country     number of sales       At the same time, I have created 2 tables with unique values for Country and Date...
Show and Tell
Tips and Tricks
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Gaizka,

    Please create a new table by clicking "new table" under Modeling on Home page, type the following DAX.

    New Table=
SUMMARIZE (
    UNION ( UNION ( Table1, Table2 ), Table3 ),
    [Date],
    [Country],
    "sum sales", SUM ( [number of sales] )
)


    If this still doesn't resolve your issue, please create dummay sample table and list expected result, so that we can share more detailed solution.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Gaizka,

Please create a new table by clicking "new table" under Modeling on Home page, type the following DAX.

New Table=
SUMMARIZE (
    UNION ( UNION ( Table1, Table2 ), Table3 ),
    [Date],
    [Country],
    "sum sales", SUM ( [number of sales] )
)


If this still doesn't resolve your issue, please create dummay sample table and list expected result, so that we can share more detailed solution.

Best Regards,
Angelia