Forum Discussion
Time sum per row then column
- 3 years ago
Solution #1: Power Query M (I can show you how)
If you want, I can prepare a solution in Power Query M, so you will recive same information without loading every row in the Power BI (recommended), but if you need every row for some reason then go for solution 2.
Solution #2: DAX Calculated TableSample Agg = SUMMARIZE( 'Sample', 'Sample'[User Name], "Elapsed Time", SUM('Sample'[NP Elapsed Time]), "Elapsed Time Other", SUM('Sample'[NP Elapsed Time Other]), "Total time", SUM('Sample'[NP Elapsed Time]) + SUM('Sample'[NP Elapsed Time Other]) )Don't forget to change this columns from datetime to time only. 🙂
Solution #3: Measures
If you don't want to create a new table. Only calculate values from the oryginal one - use measures.
Elapsed Time = SUM('Sample'[NP Elapsed Time]) Elapsed Time Other = SUM('Sample'[NP Elapsed Time Other]) Elaped Time Total = [Elapsed Time] + [Elapsed Time Other]Don't forget to format this measures to time format. 🙂
Then the Solution would be to convert the time to numbers then sum them up
Follow this video, It would help you.
I was able to calculate everything in decimal point, but im still unable to convert to hh:nn:ss. I need all calculations in time format. Changing the format of the column doesnt work.