Create a new table adding duration of different line depending on the duration between 2 entry

[sdlx]

Hi,

I am trying to generate a table with by device the duration of each changeover done on that line.

I have as raw data a table with those column

Each entry give me aduration ofr a part of changeover on on the device. The changeovers are cut in several part and I need to agregate them in only one row to have the total duration of the changeover.

When the start time of the next entry is later than 60 minutes than the End time of the Entry, the next entry can be considered as another changeover.

I have here selected the entry that needs to be considered as one changeover. for weach I need to have one total duration.

Thanks in advance for your help

[daxer-almighty · Accepted solution]

@sdlx 

You have not received any replies... That means people don't understand your problem. Please therefore read this post -> https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-...