Forum Discussion
Helper IIIIf Statement
Helper IIII get this error:
A single value for column 'receiveddate' in table 'sr' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Super Userlc1 Are you adding this as a measure or column? The dax I proposed suppose to be a column.
And you might run into another error, we are returning number but in else condition we are returning text, but let's see if we have add this expression as a column.
- lc1
It was as a calculated column, but I used the same formula adding a column and it gives me #ERROR
- parry2k
lc1 can you try follownig, I'm shooting in dark without looking at data model.
Response Time = IF(sr[source]="c", DATEDIFF(sr[receiveddate],sr[closingdate], DAY))
Make sure to add as a column? And I assume datatype for both receivedate and closingdate is date.
- lc1
Thank you very much, it worked.