grouping by values

[learning100]

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?

[vicky_]

This thread has a similar question that has been answered: https://community.fabric.microsoft.com/t5/Desktop/How-to-get-value-from-last-date-most-recent-by-cat...
You should be able to adapt a solution to fit your needs.