I have 3 SharePoint lists that have been joined in Tableau. Each has their own "Created" date column. The join puts all 3 sets of columns into a single row. I'll only have one date in a row, regardless of the particular list. It's all a weird workaround, but it works.
I need a calculated field to look at the row with 3 date fields, and pull the result of whichever is not blank. I've successfully used this for non-date formats, but can't get multiple other options to work with dates.
IFNULL([Created By (SALES)],"")
+IFNULL([Created By (Save)],"")
+IFNULL([Created By (Service)],"")
Any tips?
1 answer
Try something like this:
IF ISNULL([Date 1])=FALSE THEN
[Date 1]
ELSEIF ISNULL([Date 2])=FALSE THEN
[Date 2]
ELSE
[Date 3]
END
