Forum Discussion

nmeliasp's avatar
nmeliasp
Regular Visitor
7 years ago
Solved

datediff calculating milestone completion cycle time

Hello i have the following data and trying to calculate date difference in days between 2 different milestone completions   Identifer Milestone Completion Completion date A X 1/1/2018 ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi nmeliasp

     

    You may use ALLEXCEPT Function as below:

    Measure = 
VAR MAX_Date =
    CALCULATE (
        MAX ( Table1[Completion date] ),
        ALLEXCEPT(Table1,Table1[Identifer])
    )
VAR MIN_Date =
    CALCULATE (
        MIN( Table1[Completion date] ),
        ALLEXCEPT(Table1,Table1[Identifer])
    )
RETURN
    DATEDIFF ( MIN_Date,MAX_Date, DAY )

     Regards,

    Cherie

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Drag Identifier to the row labels and use this measure

 

Date Diff in Days = MAX(Data[Completion_Date])-MIN(Data[Completion_Date])