Looking at the data - do you ever have more than one date in a row? - At the moment you have A Date, rest are null, then rows of B date, then rest are Null?
If no, then I would create a single Date dimension:
date(zn(float([A Date]))+zn(float([B Date]))+zn(float([C Date]))+zn(float([D Date]))+zn(float([E Date])))
and use this to filter
THANK YOU Alex! This worked like a charm. I do not have multiple dates on a single row, so your formula worked great. I was pretty sure it was just my lack of programming knowledge with regard to calculated fields that was holding me back.
Just for my own info & knowledge, could you explain what each of these functions is doing in the formula and why it works?
1 of 1 people found this helpful
Starting with dates - in all systems they are represented as some sort of number from from an epoch date. In Excel's way of doing it, today is the 41,381st day past their epoch.
So given all of your other dates are nulls, we need to change them to type float from a number (kind of irrelevant as they are nulls anyway), then NULL in Tableau is really that - not a number, so we use zn() to change nulls to 0, or keep the date as a float if it's not null. Add them all up: 41,308+0+0+0+0 and change that back to a date()