Number of Days between two Date Measures

[Sdhn420]

Hi,

I have two measures with calculated date values. 

Measure 1: 

Pre_Joining_Completed = CALCULATE(MAX(Category_Combined[Date_Value]),Category_Combined[Category]="Pre-Joining")

Measure 2:

Checklist_Created = MIN(Emp_Benefits[Created])

How can i create another measure to find number of days between them?

[TomMartens · Accepted solution]

Hey @Sdhn420 ,

returning the number of days between two dates is quite straight forward, as dates are stored as decimals internally. For this reason the below sample returns 15, you might have to consider adding 1 if you want to count the start date as well.

Days between dates = 
var measure1 = DATE( 2021 , 6 , 2 )
var measure2 = DATE( 2021 , 6 , 17 )
return
INT( measure2 - measure1 )

Hopefully, this provides what you are looking for.

Regards,

Tom

[TomMartens · Accepted solution]

Hey @Sdhn420 ,

returning the number of days between two dates is quite straight forward, as dates are stored as decimals internally. For this reason the below sample returns 15, you might have to consider adding 1 if you want to count the start date as well.

Days between dates = 
var measure1 = DATE( 2021 , 6 , 2 )
var measure2 = DATE( 2021 , 6 , 17 )
return
INT( measure2 - measure1 )

Hopefully, this provides what you are looking for.

Regards,

Tom

[Sdhn420 · Accepted solution]

Thank you so much! This is exactly what I was looking for!