Forum Discussion
Time duration between rows in same column
If you want to do this in the query rather than as a DAX column you could use a technique like the following to join to the previous row https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/power-bi-data-sources/power-query-get-value-from-previous-row/
Thanks d_gosbell and apologies for the lack of clarity
I am attempting to create a new column in the querry editor that produces a time difference/duration time based on current row to the preceeding row of the Arrival Time column after the Arrival Time column has been sorted in Ascending order.
your solution allowed me to create a time difference column by creating a new column if modelling but I can not sort the Arrival Time in Ascending order as the arrival time is sorted in Date Hierarchy format Year/Quarter/Month/Day
If you want to do this in the query rather than as a DAX column you could use a technique like the following to join to the previous row https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/power-bi-data-sources/power-query-get-value-from-previous-row/