If Statement

[lc1]

Hello,

I need to create the following formula in DAX:

excel:

if (column 1="C", column 5-column 7, "Open"

PBI:

Response Time = IF(sr[source]="c", calculate (sr[receiveddate]-sr[closingdate]),"Open"))

Please advise how to do it, I tried many different ways but I keep getting a syntax error (invalid token, line 1, offset 30, 'sr[receiveddate]-sr[closingdate]),"Open")))))

[parry2k]

@lc1 try this

Response Time = IF(sr[source]="c", 
DATEDIFF(sr[receiveddate],sr[closingdate], DAY),
"Open")

[lc1]

I 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.

[parry2k]

@lc1 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 · Accepted solution]

@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]

Sorry, I accepted the answer but I'm missing the last part of the condition:

like if it is "C", substract Received Date from Closed Day, else, "Open"

[parry2k]

@lc1 try this

Response Time = IF(sr[source]="c", 
FORMAT(DATEDIFF(sr[receiveddate],sr[closingdate], DAY), "####" ),
"Open")

[lc1]

Thank you very much, it worked.