cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@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. 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

1 REPLY 1
parry2k
Super User
Super User

@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. 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!