I want to calculate time differences in PowerPivot/PowerQuery/Power BI but I can't get it to work between days.
In excel I could use 1904 dates and it somewhat works.
How should I structure date & time data to correctly calculate time differences between dates and hours with dates and hours.
I have tried with date, date and time but it doesn't work.
So I would be glad if someone could show me how to calculate time differences correctly using DAX or PowerQuery?
In excel I could use 1904 dates and it somewhat works.
How should I structure date & time data to correctly calculate time differences between dates and hours with dates and hours.
| Arrival time | Exit time | Time |
| 2020-03-24 21:15:59 | 2020-03-25 04:14:00 | ##### is displayed instead of actual time difference |
| 2020-03-23 07:00:00 | 2020-03-23 09:00:00 | 02:00:00 hours |
I have tried with date, date and time but it doesn't work.
So I would be glad if someone could show me how to calculate time differences correctly using DAX or PowerQuery?
