Forum Discussion
Calculating days between Finish Time to Finish Time
Hello, I have the following data and trying to calculate days between Finish Dates, the desired output is highlighted in yellow in the second pic below: First Pic: Data Layout ...
johnyip
Solution Sage
Solution SageHi Anonymous , can I know how to determine the start date / time? Without that info, it is hard to assist.
I was trying the following expression but this calculates days between Min and Max date (2 parents), does not work with more than 2 Parents. Saw this on another post.
Measure =
VAR MAX_Date =
CALCULATE (
MAX ( Table1[Finishdate] ),
ALLEXCEPT(Table1,Table1[Parent])
)
VAR MIN_Date =
CALCULATE (
MIN( Table1[FinishDate] ),
ALLEXCEPT(Table1,Table1[Parent])
)
RETURN
DATEDIFF ( MIN_Date,MAX_Date, DAY )
- johnyip
Yes, by this DAX it obviously calculates the difference between the largest and smallest date within your data, which is not you wish to calculate.