1 of 1 people found this helpful
I personally think the right approach here is to modify your underlying data. It can get hard keeping track of fixes like this through Tableau if you use this data a lot.
However, you could create a new calculated field to 'fake' the date.
IF [Hospital] = 2 then #2016-07-01# else [Date] end
Hi Tom, thanks for that idea. I agree that fixing it would be far better, but we are restricted due to the source data being needed by another service.
A calculated field may be just the thing - this particular report is only used once a month, and it would only be an issue for this financial year.