Lookup Max Value from related table

Hi again,

I have had so much success with solutions I thought I would try my luck again. As I am learning PBI, I am still working through even the basic of functions sometimes!

I want to create a new column 'in Results Table' that looks up 'questionid' in table named 'Evaluatons Forms' and return the highest value in the 'answervalue' column.

Essentially : 

but with MAX result

Example:

I am unable to share my Pbix, but happy to provide more details if required.
I'm almost 100% sure my request is more than on the basic side

Thanks!

Evaluations Forms Table

Results Table