No of days based on Project Status

[ninimoke]

Hi all, I have a table with date and project status which has "On-Hold, 'In-Progress" and "Completed". Based on the date field, I want to get only the project with status "On-Hold" and "In-Progress" that has the oldest date(Min Date I assume), and also have the count of the number of days from the date file till present.

Here is the sample data;

Overall Project Status	Initial Contact Date
On-Hold	14-Nov-22
In-Progress	14-Nov-22
In-Progress	14-Nov-22
In-Progress	14-Nov-22
In-Progress	14-Nov-22
On-Hold	14-Nov-22
On-Hold	14-Nov-22
On-Hold	29-Sep-22
Completed	6-Jan-22
Completed	14-Feb-22
Completed	26-Jan-22
In-Progress	14-Nov-22
On-Hold	14-Nov-22
On-Hold	14-Nov-22
On-Hold	29-Sep-22
Completed	6-Jan-22
Completed	14-Feb-22
Completed	26-Jan-22

The final result should be something like:

[tamerj1 · Accepted solution]

@ninimoke 

Oh sorry 

you can try

Initial Contact =
CALCULATE ( MIN ( 'Table'[Contract Date] ), KEEPFILTERS ( 'Table'[Project Status] IN { "On-Hold", "In-Progress" } ) )

[tamerj1]

Hi @ninimoke 

please use

Initial Contact =
MIN ( 'Table'[Contract Date] )

Number of Days =
DATEDIFF ( [Initial Contact], TODAY ( ), DAY )

[ninimoke]

Hi @tamerj1 , thanks for the reponse, in this case I am looking to show only 2 records as per my first post(one for on-hold and onr for in-progres) I am not totally sure how to achieve that