Forum Discussion

AtharNoraiz's avatar
AtharNoraiz
Frequent Visitor
7 years ago
Solved

difference between rows of a date column

how i can calculate difference b/w rows of a Task date column as  calculated column  
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi AtharNoraiz,

     

    Add an index column first in Query Editor mode.

     

    Then, create a calculated column with below DAX.

    Datediff =
DATEDIFF (
    CALCULATE (
        MAX ( Table4[Task Date] ),
        FILTER ( Table4, Table4[Index] = EARLIER ( Table4[Index] ) - 1 )
    ),
    Table4[Task Date],
    DAY
)

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi AtharNoraiz,

 

Add an index column first in Query Editor mode.

 

Then, create a calculated column with below DAX.

Datediff =
DATEDIFF (
    CALCULATE (
        MAX ( Table4[Task Date] ),
        FILTER ( Table4, Table4[Index] = EARLIER ( Table4[Index] ) - 1 )
    ),
    Table4[Task Date],
    DAY
)

 

Best regards,

Yuliana Gu

AtharNoraiz's avatar
AtharNoraiz
Frequent Visitor
7 years ago

thanks works perfect