Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Create table or column with last modified date

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.

Need Help

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      Thank you very much, it helped me a lot.

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