Forum Discussion
Min,Max Date/ Value for set of rows
i want create measure / column to get Min (Creation Date) for Selected filter.
lbendlin
Super User
Super UserGood. 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.
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
