Min date for every gro

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

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