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,

Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

Best Regards,
Angelia