Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi @Anonymous ,
Try this:
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |