1 of 1 people found this helpful
I don't know what changed,
but I think the problem is in the date literals in [End Date] and [Duration]
I changed them to #06/01/2017# and it seemed to work better
If DATE([End1]) >= #06/01/2017# then TODAY() ELSE [End1] END
IF DATE([End1])>= #06/01/2017# THEN TODAY() - [Start] ELSE [End1]-[Start] END
What version of Tableau Desktop are you using?
Yep that sorted the problem. Now I really wonder why it used to work with the previous formula but not anymore?
Either way interesting fact I just noticed (not related to initial problem), one of the gant bars was over streched without end date, and realized it was because my Tableau desktop accepts Date in European format (dd/MM/yyyy) but Tableau Public has the american format (MM/dd/yyyy).
Thanks for the help Swaroop!
Glad it worked out.
Interesting, I didn't know about that difference between Desktop and Public.
Very nicely done dashboard.
All the best.