Calculate duration between a list of times in Report View Table

[pshah090]

Hi, 

I have the following list of times. How can I calculate the duration this set of times adds up to? There is a time gap from 12 pm - 2 pm which prevents me from doing a simple MAX time - Min time. 

Thank you!

[amitchandak]

@pshah090 , Not very clear.

But you can calculate Gap between two values

A new column

=

datediff([Start Date],minx(Filter(Table, [Start Date] > earlier([Start Date]) ), [Start Date]), second) 

For measure consider offset

Continue to explore Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s