Date difference - When two dates in different rows and columns

[urspalani]

Hi,

I want to calculate the date difference ,

ED - SD where SD and ED are different Columns and different rows,

Anyone having idea,

Thanks,

[v-chuncz-msft · Accepted solution]

@urspalani,

Add an index column in Query Editor and a calculated column in DAX.

Column =
VAR ed =
    IF (
        Table1[Type] = "Arr",
        LOOKUPVALUE (
            Table1[ED],
            Table1[Index], Table1[Index] + 1,
            Table1[Type], "Dep"
        )
    )
RETURN
    ed

[Phil_Seamark]

Hi @urspalani

Do you have any other columns to link the top 2 rows together (I assumed they are linked), but not to the bottom two?

[urspalani]

They are linked based on Arr & Dep

[Phil_Seamark]

So is all the data sequential?  Whats to stop linking the top row from the bottom row?

[urspalani]

This is just a example,

In real time i will get different Report type that is Arr,Dep,ONH,BOSP,EOSP

I have to find the difference always for Arr & Dep ,it will appear in different line not next two each other ,Based on Report type i have find the difference in dates,