Calculate by diagonal only if name are equals

[Anonymous]

I want to calculate break between starting date and ending date by only if name are equals.

( 10:16:30  -  10:15:30  = 00:01:00) 

e.g.

Starting date      |    Ending date      |      Name

10:15:00              |     10:15:30          |       A

10:16:30              |    10:18:24           |       A

09:01:30              |    09:02:43          |        B

10:01:00              |    10:02:41          |        B

[Anonymous]

I want to calculate break between starting date and ending date by only if name are equals.

( 10:16:30  -  10:15:30  = 00:01:00) 

e.g.

Starting date      |    Ending date      |      Name

10:15:00              |     10:15:30          |       A

10:16:30              |    10:18:24           |       A

09:01:30              |    09:02:43          |        B

10:01:00              |    10:02:41          |        B

[harshnathani · Accepted solution]

Hi @Anonymous ,

https://community.powerbi.com/t5/Community-Blog/Getting-Previous-Values-in-Power-BI-Part-1/ba-p/1143370

Get the values from the previous row and subtract.

Regards,

Harsh Nathani

[Anonymous]

@harshnathani  thank you 🙂

[lbendlin]

How do you plan to display the results? grouped by name?  What if there are more than two rows per name? Should it only ever consider the last two?