Find min and max date in relationship order number

[lifesafari]

Hello,

i have a table like this and i need to create a new two colum to have the date start and date end (min and max) for each order (ordine di produzione). 

For example order 5650734146 must be have start date at 03/01/2024 18:50 and finish date at 04/01/2024 03:15.

ORDER	START	END
5650734146	03/01/2024 18:50	03/01/2024 20:15
5650789756	02/01/2024 19:25	02/01/2024 20:35
5650734146	03/01/2024 23:33	04/01/2024 03:15
5680987844	30/01/2024 23:33	30/01/2024 23:53

This is an example and this is my file https://docs.google.com/spreadsheets/d/1r6UTQPQ-OUUUFM4LO9OtHfZwSHcNnIUyulhNorJbE7M/edit?usp=sharing

[JamesFR06 · Accepted solution]

Hi @lifesafari 

I create a table new dates with your sample :

End = calculate(max('New dates'[Fine Fermo Tecnico]),ALLEXCEPT('New dates','New dates'[Ordine Produzione]))

Start = calculate(min('New dates'[Inizio Fermo Tecnico]),ALLEXCEPT('New dates','New dates'[Ordine Produzione]))