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.