calculate between different row and columns if conditions are met

[Anonymous]

Would like to calculate the time difference between end and start if Index = test2 and then create a new column reflecting the value difference... any help would be greatly appreciated! Still in the midst of transforming the data inside Power Query Editor

[Anonymous]

Hi,

From what I understand, and what is seen in the picture, the index column doesn't match the [test2] column in any row. But if you want to create the formula I would suggest doing so in DAX after your transformation is done. I 'd do something like this: 

Dif = if("TableName"[Index]= "TableName"[test2],DATEDIFF("TableName"[start],"TableName"[end]),#Not sure what you want if it returns false

I hope that helps.

[Anonymous · Accepted solution]

managed to resolve this w help from a power query M guru from youtube...

Refer to Previous Row for Subgroups in Power Query - YouTube

Thank you all for viewing and have a nice day!