Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

getting single column from filter function

ok so say i have a table with a list of names and dates

 

jim 2/5/2020

jim 2/3/2020

jim 2/25/2020

 

and i have another table with names that has a many to one association with the above table so

 

Jim

 

i want to find what the most recent date is and save it in the single table like

 

jim 2/25/2020

 

I know MAX will get you the highest date but i can't seem to figure out how to filter the first table based on a name and then just get the date column from the filter function to check the max on

 

1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

Hi @Anonymous ,

 

Try this:

Capture 0.PNGCapture.PNG



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

Proud to be a Super User!



View solution in original post

2 REPLIES 2
v-yingjl
Community Support
Community Support

Hi @Anonymous ,

 

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!


Best Regards,
Yingjie Li

camargos88
Community Champion
Community Champion

Hi @Anonymous ,

 

Try this:

Capture 0.PNGCapture.PNG



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

Proud to be a Super User!



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.