Hey I need help with this
I got a table
I need the accumulate time for instance. the value to searching for key "K1" is "04:45" I need to sum for each until the max sequence, and the expected result, must be:
First step the value "04:45" is in the next row:
the result is "04:45" + "00:20" = "05:05"
after that, the new value to search is "05:05" and the second step is
the result is "05:05" + "01:50" = "06:55"
Final result 06:55
and if the key has more values for sequence, it must to continue until the max value of sequence.
normally this problem it's solved with a loop and auxiliary variables, but I don't know how to solve this problem with DAX.
Please your help with this prblem Thanks...!!
@ralfgomezc , Refer if this can help
Convert to second/ Min first and sum and convert back
In Min = hour([Time])*60 + minute([Time])
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.