Forum Discussion

Switto's avatar
Switto
Icon for Helper IV rankHelper IV
6 years ago
Solved

Datediff with IF condition

Hi All, I am trying to find aging between On hold cases and responded cases(Approved or Rejected).   Most of the time, cases go without hold so no date will be provided for that particular line it...
Need Help
  • Switto's avatar
    Switto
    6 years ago

    Thanks Amit for the response.

     

    However, I got the solution. I forgot to add ISBLANK in one of the lines.

     I got the desired result.

    Thanks for taking the time.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Switto ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Switto's avatar
Switto
Icon for Helper IV rankHelper IV
6 years ago

Thanks Amit for the response.

 

However, I got the solution. I forgot to add ISBLANK in one of the lines.

 I got the desired result.

Thanks for taking the time.