Forum Discussion
Solved
difference between rows of a date column
how i can calculate difference b/w rows of a Task date column as calculated column
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
3 Replies
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
thanks works perfect
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/339586
