DAX sum if duplicates

[gregwinter]

Hi there,

I am looking to find the time between two points. There is information recorded at the start and again at the end. Example outcome data shown below:

I have tried to create an IF statement but with no success.

Is it possible to create the 'Cycle Time (minutes)' column with this data set? 

Any help will be greatly appreciated 🙂

[Anonymous · Accepted solution]

@gregwinter Please try below measure. I'm assuming that you want to find difference in min and max of each serial number

Measure = 
VAR _start = CALCULATE(MIN('Table'[Time]),ALLEXCEPT('Table','Table'[Serial No]))
VAR _end = CALCULATE(MAX('Table'[Time]),ALLEXCEPT('Table','Table'[Serial No]))
RETURN IF(MAX('Table'[Sation])=2, DATEDIFF(_start,_end,MINUTE))

[gregwinter]

Brilliant, this works!

Thanks for your effort!