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