Forum Discussion

ToddMate's avatar
ToddMate
Helper II
7 years ago
Solved

DateDiff where End Date is Null

Hi All,   I need assistance, with dates and tenures .. but not the usual A Date - B Date scenario as i have a measure to do this. What i am looking for is an extension to this measure where, if the...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi ToddMate ,

     

    You can use the code below.

    Tenure =  1.0 * ( IF(X_Churns[Churn Date] = BLANK(), TODAY(), X_Churns[Churn Date]) - X_Connects[Connect Date] )

    Hope it helps.

    Mariusz

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi ToddMate ,

 

You can use the code below.

Tenure =  1.0 * ( IF(X_Churns[Churn Date] = BLANK(), TODAY(), X_Churns[Churn Date]) - X_Connects[Connect Date] )

Hope it helps.

Mariusz

ToddMate's avatar
ToddMate
Helper II
7 years ago

Mariusz  Hey thankyou so much! This works perfectly!