Working with Measures & Dates, "A single value... cannot be determined" (New User here!)

[bjj8383]

Basically, I'm trying to track if Closed items were completed on time. If Closed, show me the time between the Due & Closed dates; if not Closed, show me the time between the Due date & today. I've set up this Measure:

Timer = IF(srsearchscreen_THIS_WEEK[Status] = Closed, DATEDIFF('srsearchscreen_THIS_WEEK'[Due Date], 'srsearchscreen_THIS_WEEK'[Closed On], DAY), DATEDIFF(TODAY(), 'srsearchscreen_THIS_WEEK'[Due Date], DAY))

However: "A single value for column 'Due Date' ... cannot be determined" I'll insert a picture of the entire data column - all values sure look the same to me. Can someone please point me towards my mistake? Tyvm.

 

[rsbin · Accepted solution]

@bjj8383 ,

In this case, appears you want to populate a value for each record in your Table.  You want to use a Calculated Column, not a Measure. I'm guessing you are after something that looks like this:

Also, be sure to put "Closed" in quotation marks as it is a text value.

Hope this resolves your issue.

Regards,