Create table or column with last modified date

[Anonymous]

Hello good morning.

I have the following related tables, both tables have a field for when they were last modified, the relationship of my main table with the secondary one is one to many.

And I need to create a new table or column within the main table where I can see which two dates are the most recent, taking into account the secondary table may have one or more dates related to a single value from the main table.

[Fowmy]

@Anonymous 

Create a table as follows:

New Table = 
ADDCOLUMNS(
	SUMMARIZE( Orders , Orders[ID_SC] , Orders[Modified_On]) , 
	"Latest Modified Date" , 
		MAX( Orders[Modified_On] , MAXX( RELATEDTABLE( Anotation ) , Anotation[Modified_On] ) )
)

[Anonymous]

Thank you very much, it helped me a lot.

How could I implement this formula to create a new column within my main table.