Forum Discussion
Solved
help calculate duration between lines
Hi guys, I need some help. I have a data file where I need to calculate the duration between lines. In excel I use the simple formula. I would like to do the same directly in powerbi. Any suggestion...
LuizMartins , Add an index column in power query
Power Query- Index Column: https://youtu.be/NS4esnCDqVw
Then create a new column
datediff(maxx(filter(Table, [Index] = earlier([Index]) -1) ,[B]), [B], second)
amitchandak
Super User
Super UserLuizMartins , Add an index column in power query
Power Query- Index Column: https://youtu.be/NS4esnCDqVw
Then create a new column
datediff(maxx(filter(Table, [Index] = earlier([Index]) -1) ,[B]), [B], second)
Perfect! Thank you very much!!