Forum Discussion
Power BI Hour Difference between two different rows from different column with a condition
So I am working with Live Data. I need a POWER BI Query to create a calculated column or Measure. What I really want is the Sum of Hours between (Start time when type = 3) and (End time when t...
Hi Greg, this is the entire table. The Hour Duration is the expected Output
Type
2
3
2
3
3
2
3
2
3
2
3
2
3
3
2
3
2
3
Start
22-01-2020 18:59
20-01-2020 09:34
20-01-2020 09:34
21-01-2020 09:33
23-01-2020 11:38
23-01-2020 13:38
22-05-2020 17:38
23-05-2020 13:38
24-05-2020 17:38
22-01-2020 18:59
20-01-2020 09:34
20-01-2020 09:34
21-01-2020 09:33
23-01-2020 11:38
23-01-2020 13:38
22-05-2020 17:38
23-05-2020 13:38
24-05-2020 17:38
End
22-01-2020 19:59
20-01-2020 10:34
20-01-2020 09:34
21-01-2020 10:33
23-01-2020 11:39
23-01-2020 15:38
22-05-2020 18:38
23-05-2020 15:38
22-01-2020 19:59
20-01-2020 10:34
20-01-2020 09:34
21-01-2020 10:33
23-01-2020 11:39
23-01-2020 15:38
22-05-2020 18:38
23-05-2020 15:38
Hours Duration
null
01:00
null
null
01:06
null
01:00
null
null
null
01:00
null
null
01:06
null
01:00
null
null
These texts are Column wise.