difference between rows of a date column

[AtharNoraiz]

how i can calculate difference b/w rows of a Task date column as  calculated column

[v-yulgu-msft · Accepted solution]

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]

thanks works perfect

[Greg_Deckler]

Use EARLIER. See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...