Forum Discussion
Time between two dates columns whilst not double counting same date & time periods
1 2 06/01/2020 08:00:00 06/01/2020 19:30:00 06/01/2020 10:35:00 06/01/2020 11:40:00 06/01/2020 08:00:00 06/01/2020 19:30:00 06/01/2020 10:35:00 06/01/2020 11:40...
3 1 2
| A | 06/01/2020 08:00:00 | 06/01/2020 19:30:00 |
| A | 06/01/2020 10:35:00 | 06/01/2020 11:40:00 |
| A | 06/01/2020 08:00:00 | 06/01/2020 19:30:00 |
| A | 06/01/2020 10:35:00 | 06/01/2020 11:40:00 |
| B | 11/02/2021 08:00:00 | 11/02/2021 17:00:00 |
| B | 11/02/2021 08:00:00 | 11/02/2021 17:00:00 |
| B | 11/02/2021 08:00:00 | 11/02/2021 17:00:00 |
| B | 11/02/2021 08:00:00 | 11/02/2021 17:00:00 |
| B | 12/02/2021 08:00:00 | 12/02/2021 14:25:00 |
| B | 12/02/2021 08:00:00 | 12/02/2021 18:00:00 |
| B | 12/02/2021 15:00:00 | 12/02/2021 15:20:00 |
| B | 12/02/2021 08:00:00 | 12/02/2021 14:25:00 |
| B | 12/02/2021 08:00:00 | 12/02/2021 18:00:00 |
| B | 12/02/2021 15:00:00 | 12/02/2021 15:20:00 |
| B | 13/02/2021 07:00:00 | 13/02/2021 20:10:00 |
| B | 13/02/2021 08:40:00 | 13/02/2021 09:00:00 |
| B | 13/02/2021 17:00:00 | 13/02/2021 18:00:00 |
| B | 13/02/2021 07:00:00 | 13/02/2021 20:10:00 |
| B | 13/02/2021 08:40:00 | 13/02/2021 09:00:00 |
| B | 13/02/2021 17:00:00 | 13/02/2021 18:00:00 |
Hi Greg, thanks for you reply. Unfortunately, the measure provided is not working with Power Bi as it can't load any values and it stuck "working on it" for long periods of time.
Also, I forgot to add that the time difference calculation (with no overlap) needs to be done for each distinct value for column 3 (as above)
Greg_Deckler
Greg_Deckler
Community Champion
Community ChampionAverageBiUser Well, it is an EXTREMELY expensive operation to do it the way that I was forced to do it. No argument there. But that was the only way I could get the correct results when I put that measure together. It's not a trivial problem.