Forum Discussion

Rajat's avatar
Rajat
Frequent Visitor
10 years ago

Retrive a value from multiple matching records

  Project Master                                                                                         Task Allocation   ProjectID  projectName  Project Status                                   ...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Rajat, First, please do not cross-post in every forum, that's not cool. A lot of us use the "All Topics" view and so we see your post four times and have no idea which one to respond to.

 

Second, try something like this:

 

IF(COUNTAX(FILTER('Task Allocation'[Task status]='In Progress'),[Task ID]) = 0,"In progress", "Completed)

 

 

 

 

Rajat's avatar
Rajat
Frequent Visitor
10 years ago

 thanks Greg_Deckler for reply and i will not do it again.