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.   ...
Need Help
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.