Forum Discussion
Calculate time between dates for each unique identifier
Hello All, I have been stuck with this issue for a while and i would appreciate some help. I have got the following table. ID Date 1 16/07/2020 14:11:12 1 17/07/2020 15:12:11 1...
Power Query has a duration data type, but this is converted to decimal number when loaded into the report: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types
See if this link helps you calculate the difference between two rows using Power Query: https://www.myonlinetraininghub.com/referencing-next-row-power-query
See if this link helps you calculate the difference between two rows using Power Query: https://www.myonlinetraininghub.com/referencing-next-row-power-query