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.

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

It was as a calculated column, but I used the same formula adding a column and it gives me #ERROR

parry2k's avatar
parry2k
Icon for Super User rankSuper User
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.

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

    Thank you very much, it worked.

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

    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's avatar
      parry2k
      Icon for Super User rankSuper User
      7 years ago

      lc1 try this

       

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