Forum Discussion
Time between two dates columns whilst not double counting same date & time periods
Community ChampionAverageBiUser This sounds like Overlap: Overlap - Microsoft Power BI Community
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
AverageBiUser 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.
Hi Greg, after implementing the column, the values for each record are returning 1 distinct value that is wrong. Do you know how I would rectify the issue?