Forum Discussion
VViskaz
6 years agoRegular Visitor
Adding all values under a key value
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 dura...
- 6 years ago
You can do it by 2 method
1- In Power Query ---> Use Group by
2- In DAX ---> Summarize
https://docs.microsoft.com/en-us/dax/summarize-function-dax
FarhanAhmed
6 years agoCommunity Champion
You can do it by 2 method
1- In Power Query ---> Use Group by
2- In DAX ---> Summarize
https://docs.microsoft.com/en-us/dax/summarize-function-dax
- VViskaz6 years agoRegular Visitor
Wow, first method was the easiest solution to a problem that tortured me for 2 hours. Thank you.