1The related function does not work with Many to Many relationships.
2Solution – You can either:
3
4a) Work with one to many relationship
5b) Use Power Query to join the two tables
6c) Or try to use the LOOKUPVALUE function to retrieve the lookup value