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...
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.