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 |