Min,Max Date/ Value for set of rows

[veerenpatil]

i want create measure / column to get Min (Creation Date) for Selected filter.

[APavlovs]

Hi @veerenpatil 

This measure does the trick 😉

Daysbetween = DATEDIFF(MIN('Table'[Creation Date]),MAX('Table'[Completion Date]),DAY)

Did I answer your question? Mark my post as a solution 🙂

If I gave you an idea on how to solve this otherwise give my post some Kudos 😄

[lbendlin]

Good.  What have you tried and where are you stuck?

Please provide sample data in usable format (not as a picture - maybe insert into a table?) and show the expected outcome.

[veerenpatil]

Thanks for your response.data

here i am attching the Snapshot. 

there some projects running and each project has some tasks, where task has some creation and completion date. so here Project is a filter , when project selected i need to get the Min (Creation Date)

Max(Completion date) for the selected Project,  where i need to calucate the total no of days for the selected project : Max(Completion date) - Min (Creation Date).  please advise me how can i achieve the same.

S.No	Project	TaskID	Assign to	Creation Date	Completion Date
1	P.23	P.23.1	Anand	02/07/2021	02/08/2021
2	P.23	P.23.2	Pradeep	03/07/2021	05/08/2021
3	P.23	P.23.3	Charan	04/07/2021	10/08/2021
4	P.24	P.24.1	Pradeep	01/07/2021	05/08/2021
5	P.24	P.24.2	Venkat	04/07/2021	04/08/2021
6	P.24	P.24.3	Raman	09/07/2021	03/08/2021
7	P.25	P.25.1	Karthik	10/07/2021	08/08/2021
8	P.25	P.25.2	Patil	11/07/2021	09/08/2021
9	P.25	P.25.3	Veerendra	12/07/2021	10/08/2021
10	P.25	P.25.4	Karthik	13/07/2021	15/08/2021