Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

Reply
HelpmeRhonda
New Member

IF & DATEDIFF - 3 Status Help with my function Please

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)& "",
""
)
 
 
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

[TASK_STATUS]<>"Completed"

 

or

 

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

View solution in original post

2 REPLIES 2
HelpmeRhonda
New Member

Thank you so much for you help! 

lbendlin
Super User
Super User

[TASK_STATUS]<>"Completed"

 

or

 

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

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.