Adding all values under a key value

Question

Hi, I really need help with this one.I have a table that has multiple User ID lines and Duration values related to them.&nbsp;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:&nbsp;

farhanahmed · Accepted Answer

You can do it by 2 method&nbsp;1- In Power Query ---&gt; Use Group by&nbsp;&nbsp;https://support.microsoft.com/en-us/office/group-rows-in-a-table-power-query-e1b9e916-6fcc-40bf-a6e8-ef928240adf1&nbsp;2- In DAX ---&gt; Summarize&nbsp;https://docs.microsoft.com/en-us/dax/summarize-function-dax&nbsp;&nbsp;

Forum Discussion

Adding all values under a key value

2 Replies

Related content

Adding Values

Adding columns

Stacked Column Chart Displays Incorrect Total Values After Adding Legend

Adding a column

Mobile App - Adding Multiple Dashboards into One