Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate customer age from date

Hi all, I want to create a measure that calculates the age of customer in months from the earliest contract start date to the current date. For example, for customer 1 the earliest contract start date is 7/20/18 so I want to have their age be the difference in months from today's date and 7/20/18. 

 

How would I write this measure calculation?

 

CustomerProduct PurchasedContract Start Date
1cloud7/20/18
1data center9/30/18
2cloud8/20/19
2data center8/30/19
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Create a new column like

    datediff(minx(filter(table,[Customer]= earlier[Customer]),[Contract Start Date] ), today(), month)

    or
    datediff(minx(filter(table,[Customer]= earlier[Customer]),[Contract Start Date] ), today(), year)

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , Create a new column like

    datediff(minx(filter(table,[Customer]= earlier[Customer]),[Contract Start Date] ), today(), month)

    or
    datediff(minx(filter(table,[Customer]= earlier[Customer]),[Contract Start Date] ), today(), year)

  • simrantuli's avatar
    simrantuli
    Icon for Continued Contributor rankContinued Contributor
    6 years ago

    Hi Anonymous ,

    Try the below measure.

     

     

    Regards

    Simran Tuli