topic DAX sum if duplicates in DAX Commands and Tips

DAX sum if duplicates

Anonymous — Mon, 09 Dec 2019 10:20:11 GMT

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 🙂

Re: DAX sum if duplicates

Anonymous — Mon, 09 Dec 2019 10:29:50 GMT

Anonymous 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))

Re: DAX sum if duplicates

Anonymous — Mon, 09 Dec 2019 10:37:34 GMT

Brilliant, this works!

Thanks for your effort!