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 ...
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)