Min date for every gro

[Anonymous]

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.

[MFelix · Accepted solution]

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 · Accepted solution]

Calculate(Min(table[Start Date]),allexcept(table[project]))

[amitchandak]

@Anonymous , three solutions has been provided. Can you please check if your problem is resolved.

[Anonymous]

sorry for late reply.

yes i have managed to achieve my requirement using all 4 solutions to gether.

Thank you,

Narendra.

[amitchandak]

@Anonymous, Please post the solution, so others can get help and mark that solution.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create one measure as below:

Min date = var a=max('project'[Project]) var b= CALCULATE(min('project'[start date]), filter(all('project'),'project'[Project]=a)) return b

Best Regards

Rena

[amitchandak · Accepted solution]

Calculate(Min(table[Start Date]),allexcept(table[project]))

[MFelix · Accepted solution]

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())