Hello,
How to display date and time in a measure cell without replacing text in cell.text
Thank you.
Hello, Ahmed,
Thank you for your question.
Date and time can be displayed in a measure cell by specifying the appropriate data type.
Please consider using the datetime JSON data type for Fields containing date-time values.
The datetime
data type is a date field that can be used for values in the pivot table. Min, max, count, and distinct count aggregations can be applied to this field.
Please see our date and time formatting tutorial for more information.
Here is a JSFiddle example for illustration.
Please let us know if you have further questions.
Best Regards,
Vera