topic Re: IF & DATEDIFF - 3 Status Help with my function Please in DAX Commands and Tips

IF & DATEDIFF - 3 Status Help with my function Please

HelpmeRhonda — Thu, 12 Dec 2024 21:35:23 GMT

I have a status Column with 3 texts: Completed, In Progress, Not Started.

I would like to pull for both "In Progress" and "Not Started" or pull for all but "Completed".

This works but what would I need to add to do what I need?

Days Open = if(

([TASK_STATUS]="In Progress"),

DATEDIFF(TEST[TASK_FINISH],TODAY(),DAY)& "",

)

Re: IF & DATEDIFF - 3 Status Help with my function Please

lbendlin — Thu, 12 Dec 2024 23:33:26 GMT

[TASK_STATUS]<>"Completed"

[TASK_STATUS] IN {"In Progress","Not Started"}

Re: IF & DATEDIFF - 3 Status Help with my function Please

HelpmeRhonda — Fri, 13 Dec 2024 17:26:47 GMT

Thank you so much for you help!