SharePoint 2013 LIst Filters (by latest date)

I am trying to sort a list by the latest date before a predefined date. I need it to also sort on 2 other columns. Basically I need the last date entered before [Date] for each drop down choice

Drop down

Column 2

Date 

End Date - (latest record after a date)

I found a few things online but I'm not sure where I would add this or what the best plan of attack would be. 

Filter(ListName,Date=First(Sort(Distinct(ListName,Date),Result,Descending)).Result)

Any help or direction is greatly appreciated.