Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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            ...
Need Help
johnyip's avatar
johnyip
Icon for Solution Sage rankSolution Sage
3 years ago

Hi Anonymous , can I know how to determine the start date / time? Without that info, it is hard to assist.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Days Diff will start for each Parent with Type X, therefore, for the first Parent (112233) and its four Children, start date will be determined by Type "X".

     

    I hope i answered your question.

      

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      johnyip
      Icon for Solution Sage rankSolution Sage
      3 years ago

      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.