Forum Discussion
Solved
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...
Thanks, using the same formula and format so guess it must be an issue with the data (or I just need to switch the PC off and on again!).
Hi Lorenzo
Yes, your file works perfectly. I'll update the post if I find my issue which I guess must be data related, thanks.
- Found it - I had a blank row at the end of my data resulting in a calculated date in the year 1899 rather than an error. Interestingly, using the calculated column in a slicer worked and did not show the spurious date whereas the Timeline just did not appear. Removed blank rows in the upload query and all works perfectly now.
- Glad you found the issue & Thanks for documenting your solution
Not sure you can mark as solution your own posts but if you can that could help other users facing the issue...
Thanks again & nice day...