Find the MAX date from Table 1 and update Table 2 based on ID

[Anonymous]

Hi!

I am looking to fill a table 2 which has unique ID with MAX dates from Table 1 which has information like dates, names and multiple information  about that ID with several row information. I need to find the MAX date from Table 1 and update the table two which has unique IDs.

Help will be greatly appreciated.

Thanks

[parry2k · Accepted solution]

@Anonymous Assuming Table 2 has relationship wiht Table 1 with One to Many, one on Table 1 Side.

Add following measure:

Max Date = MAX ( Table1[Date] )

Drop table visual and Id, and above measure from to see the result.

Would appreciate Kudos 🙂 if my solution helped.