Below is the data I would like to sort using the firstsortedvalue function.
My issues is if a milestone has the same date as another milestone it returns no value and it won't let me nest another firstsortedvalue in the sort-weight to use the order column to pick the milestone with the highest order.
How can I use the firstsortedvalue order to pick highest ordered milestone if the dates are the same.
Thanks for the help but it inst not working as in the dataset if there are no dates it still pulls in the firstvalue milestone so it shows a value if though there is no date for that value. I will work with this method and see if I can get it to work and let you know.
Also if I want to use the function below it returns null() even though there are dates. I know why it does but don't know how to make it look down the column until it finds a value if you null() the firstvalue because it is before it occur before the date in the if statement.
FirstValue(if(Date1 < '1/04/2017',Date1)) as Date1,
Let me know if there is another way to solve the problem.