Customer experience | Sales, Customer Insights,...

How do I create a custom measure that measures time since a date?

(3) Share

Report

Posted on by CU03091316-0

174

With the limited amount of functions and operators available in CI-D to create custom measure, I am struggling to do this. Essentially, I want to create a custom measure that displays number of years (formatted like NN.N) since a person became a customer (which can be read from a date field in a table related to the contact record). Any ideas on how to solve this without access to more advanced tools?

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Hamza H 2,027 Super User 2026 Season 2 on at

Like (2)

Report
Copy link

Link copied!
Use this custom measure in CI-D:

DateDiff(customerSinceDate, Now()) / 365.0

It calculates years since becoming a customer. Formatting (e.g., NN.N) can be handled in Power BI.

Was this reply helpful? Yes No
CU03091316-0 174 on at

Like (1)

Report
Copy link

Link copied!

The suggested answer with datediff does not do the job, as this is menu driven in CI-D and the only available choices are the ones listed in this screenshot:

Was this reply helpful? Yes No
Suggested answer

Quartzite 135 on at

Like (0)

Report
Copy link

Link copied!

Yes, creating a custom measure in Customer Insights - Data (CI-D) with limited functions can be tricky, especially when you want to do something like calculate the number of years since a customer joined.

- Use the DateDiff() function (which is supported in CI-D measures)

- Divide the number of days by 365.25 to approximate years (accounts for leap years).

- Round or format to 1 decimal if possible (depending on formatting capabilities in UI or destination).

Was this reply helpful? Yes No
CU03091316-0 174 on at

Like (1)

Report
Copy link

Link copied!

To those of you replying this can be solved with the datediff function: This is not available for building measures in CI-D. The only available funcitons you can choose from in the measure definition screen are: Sum, Average, Count, Count Unique, Max, Min, First, Last, Argmax and Argmin.

Non-AI generated replies with an answer that solves the problem are welcome :-)

Was this reply helpful? Yes No

Join the conversation

Community site session details

How do I create a custom measure that measures time since a date?

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

How do I create a custom measure that measures time since a date?

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates