Forum Discussion

Mariska123's avatar
Mariska123
Frequent Visitor
8 years ago

Calculate date difference

Hi Community,   I'm trying to calculate the date difference between the bold dates:   Client_NR Sit_NR Mutation Input Start Date End Date 1 1 NW 1-3-2015 1-4-2015 28-2-2016 1 ...
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI Mariska123

 

Is the value you want to calculate always between two records with consecutive Sit_NR numbers?

  • Mariska123's avatar
    Mariska123
    Frequent Visitor
    8 years ago

    Hi Phil_Seamark,

     

    Yes, that's right. The date I want to create is the difference between the startdate of mutation = NW and the inputdate of the mutation = SC

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      try this measure

       

      Days Difference = 
var y = calculate(max(Dt[Start Date]), Filter(ALLSELECTED(Dt), Dt[Sit_NR] < max( Dt[Sit_NR] )))
return   datediff(y, MAX(Dt[Input]), DAY)
    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      8 years ago

      Are there always just 2 rows, or are there subsequent SC rows that you would also like a DATEDIFF calculated for?

      • Mariska123's avatar
        Mariska123
        Frequent Visitor
        8 years ago

        The mutation column can have up to 6 different values. The client will always hav the NW mutation, but not necessarily one of the others. I only want to calculate the date difference if both mutations NW and SC are available for the client.