Use the Primary data source Data field - Write a calculation max(date field) will give Aug 3rd
Hope this helps
Kindly mark this answer as correct/helpful so that it will help others
If it didn't helps kindly attach the workbook with fake data
1 of 1 people found this helpful
If I am getting you right, you can do this by using Max([FirstSourceDate] ) in the calculation. So the condition would refer to the max date from the first data source and will get automatically updated as your first source changes.
Hope this helps.
got it thanks