Forum Discussion

Splat23's avatar
Splat23
Copper Contributor
Jan 06, 2023
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...
excel
Splat23's avatar
Splat23
Copper Contributor
Jan 06, 2023
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!).
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jan 06, 2023

    Splat23 When you open the workbook I shared, does it work?

    • Splat23's avatar
      Splat23
      Copper Contributor
      Jan 09, 2023

      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.

      • Splat23's avatar
        Splat23
        Copper Contributor
        Jan 09, 2023
        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.