Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
how i can calculate difference b/w rows of a Task date column as calculated column
Solved! Go to 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
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/3395...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |