please see the attached potential solution
on your Max Value sheet
place date on the filter shelf and set to Context
then add a show hide filter based on the windowmax of date as shown
it returns this on you db
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
IssueonDate_v10.2.twbx 33.4 KB
Thanks a lot for the help.
Glad to help out