Earliest and latest date

Thanks for the reply from Greg_Deckler and BIswajit_Das.

Hi Anonymous ,

Based on the existing replies, I created simple data and used measures to achieve the desired effect.

This is the simple data:

1.If you want to get the total earliest and latest dates, you can use the following measures:

Maxdate = MAXX(ALL('Table'),'Table'[Date])

Mindate = MINX(ALL('Table'),'Table'[Date])

Result:

2.To get the respective earliest and latest dates for each material number, use the following measures:

Maxdate2 = CALCULATE(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[MaterialNumber]))

Mindate2 = CALCULATE(MIN('Table'[Date]),ALLEXCEPT('Table','Table'[MaterialNumber]))

Result:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.