how i can calculate difference b/w rows of a Task date column as calculated column
Go to Solution.
Add an index column first in Query Editor mode.
Then, create a calculated column with below DAX.
MAX ( Table4[Task Date] ),
FILTER ( Table4, Table4[Index] = EARLIER ( Table4[Index] ) - 1 )
View solution in original post
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/3395...
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.