Hi,
I am trying to create a filter for students where I only call the most recent entry from a database.
This is the script I have at the moment;
LOAD uniqueID,
max([Predicted End Date]) as [Expected Completion Date]
Resident learnerData
Group By uniqueID;
I would like to add an additional filter where the max([Expected Completion Date]) is only called if the course the learner is on is the same course.
Any help is much appreciated.
Thanks.
