Hi! how to sum some values in a table to build a new table

[Anonymous]

Hello! I have  a table like

id   customerid  waitingtime cost

1    001                3                  5

2    001                2                  12

3    002                3                   12

4    002                5                   23

.......

I have tens of thousands of customers, and I need to sum waitingtime and cost for each customer in a new table, like

customerid  waitingtime cost

001                5                 17

002                8                  35

............

so that I can connect this new table with another table using customerID. Could anyone help on it? Thanks!

[pranit828 · Accepted solution]

Hi @Anonymous 

Create a new table using the new table button on Modelling tab and use the below dax to do so.

SUM_Table = SUMMARIZE('Table','Table'[customerid ], "waitingtime", SUM('Table'[waitingtime]), "cost", SUM('Table'[cost]))

[Anonymous]

Thanks a lot! It works!