Hello Power BI community!
I'd like to share with you one of the ways to lookup multiple columns in Power Query (you might use VLOOKUP function if you're an Excel user).
There are some cases when merging queries is not an option / causes performance issues. But there is an alternative: by using the M language we can make a lookup function.
Read more...
CustomFunctionMultipleLookup.pbix