grouping by values

Hi, 

Thanks for looking at my post. Very new to PBI here. 
I am trying to calculate the latest derived_account_health for each quarter (I want to show the latest health by qtr) However, the aggregation only lets me do First and last which is just sorting the health alphabetically. I actually want the latest value associated with the qtr. 
The table on the right actually shows when the snapshot was taken and the derived health in a non summarized form. Can someone please point me in a direction or guide me to achieve this?