Forum Discussion
Splat23
Jan 06, 2023Copper Contributor
Timeline on calculated column
Hi,
Question: can a calculated column be used for a 'Timeline'?
I have a table within a data model that has two date columns: one column contains source data and one is a calculated column which uses the DATE formula to return the date value based on other columns' source data (from the same table). I have a pivot table summarising the data model and would like to add a timeline. 'Insert Timeline' shows both date columns are available for selection - all good so far. The column containing the source data gives me a working timeline. If I remove the source data timeline and select the calculated column, however, no timeline appears. Both columns have the same date format.