Adding all values under a key value

[VViskaz]

Hi, I really need help with this one.

I have a table that has multiple User ID lines and Duration values related to them. 

I need to put in new table distinct User_ID values and add up all the duration values.

Source table looks like this:

I need to make it look like this:

[FarhanAhmed · Accepted solution]

You can do it by 2 method

1- In Power Query ---> Use Group by 

https://support.microsoft.com/en-us/office/group-rows-in-a-table-power-query-e1b9e916-6fcc-40bf-a6e8...

2- In DAX ---> Summarize

https://docs.microsoft.com/en-us/dax/summarize-function-dax

[VViskaz]

Wow, first method was the easiest solution to a problem that tortured me for 2 hours. Thank you.