Create new column based on multiple conditions from a related table

Hi all,   I am currenlty learing PowerBI and also attending training classes. Therefore, coming across more and more use cases. One of which I struggle right now on how to solve it. I hope someone ...