How to use MAX Date in OTBI

Content

Hi 

I'm getting multiple work relationship records, I would like to return only the latest work relationship record.  How can use MAX function to select the latest row?

ex. we have partners and there is Partnership Start Date. if partner get promoted to next level I'm getting 2 rows for same partner.

Name	Partner Level	Start Date
abc	Level1	12/12/2019
	Level2	12/12/2020
xyz	level3	12/12/2020

So in this ex, I want one row for abc with start date 12/12/2020.