Calculated Column: DateDiff, but if no 2nd date, use todays date.

[StuartSmith]

I current have a calculated column that counts the number of days between a column called "End Date" and "Positon Filled" and works great when there are dates in both columns, if there is no date in the "Positon Filled" cloulmn, the "Time to Fill" column is empty.  Whats the best way to get the coulmn to use "Today" if "Position Filled" is empty?

Time to Fill = DATEDIFF('Cuser Archive data'[End Date +1], 'Cuser Archive data'[Position Filled +1], DAY)

Hope this makes sense.

[Greg_Deckler]

@StuartSmith Try:

Time to Fill = 
  VAR __Date = IF([Position Filled + 1] = BLANK(),TODAY(),[Position Filled + 1])
RETURN
  DATEDIFF('Cuser Archive data'[End Date +1], __Date, DAY)