Forum Discussion

ToddMate's avatar
ToddMate
Icon for Helper II rankHelper 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
Icon for Community Champion rankCommunity 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
    Icon for Helper II rankHelper II
    7 years ago

    Mariusz  Hey thankyou so much! This works perfectly!

  • ToddMate's avatar
    ToddMate
    Icon for Helper II rankHelper II
    7 years ago

    Hi Mariusz ,

     

    I was wondering if you could help out on an extension of this measure.

    The table above shows the Connect Date and the Churn Date and then calculates the Tenure which works great.

    How would you determine the average tenure based on grouping of the account number column ?