Forum Discussion
Min date for every gro
Hi All,
can somebody please help me.
i have below data.
Project 1 | Mile Stone | start date | |
| milestone1 | 01/02/2020 | ||
| milestone2 | 11/02/2020 | ||
| milestone3 | 21/02/2020 | ||
| milestone4 | 26/02/2020 | ||
| Project 2 | |||
| milestone1 | 01/03/2020 | ||
| milestone2 | 11/03/2020 | ||
| milestone3 | 21/03/2020 | ||
| milestone4 | 26/03/2020 |
now i want to create out put, min date of every section. strange requirement is i want to keep projects in slicer and min date should change by slicer selection (if i select project 1 it should return 01/02/2020 same for project 2 01/03/2020.
thanks in advance.
Thank you,
Narendra.
Hi Anonymous ,
You have two options or change the sumarization to the minimum value (first value) if you want you can also create a measure similar to:
MIN(Table[StartDate])Be aware that depeding on the way you place things in the visualizaiton you may need to make some adjustments so that the measure is blank when more than one project is selected.
Similar to this:
IF(DISTINTCTCOUNT(Table[Project]) = 1; MIN(Table[StartDate]); blank())Calculate(Min(table[Start Date]),allexcept(table[project]))
6 Replies
- MFelix
Super User
Hi Anonymous ,
You have two options or change the sumarization to the minimum value (first value) if you want you can also create a measure similar to:
MIN(Table[StartDate])Be aware that depeding on the way you place things in the visualizaiton you may need to make some adjustments so that the measure is blank when more than one project is selected.
Similar to this:
IF(DISTINTCTCOUNT(Table[Project]) = 1; MIN(Table[StartDate]); blank()) - amitchandak
Calculate(Min(table[Start Date]),allexcept(table[project]))
- amitchandak
Anonymous , three solutions has been provided. Can you please check if your problem is resolved.
- amitchandak
Anonymous, Please post the solution, so others can get help and mark that solution.