Forum Discussion

lc1's avatar
lc1
Icon for Helper III rankHelper III
7 years ago
Solved

If Statement

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]),"Ope...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    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.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

lc1 try this

 

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