I wrote a tip earlier on this – VLOOKUP/XLOOKUP Formula – Power Query – Tips & Tricks 7
Here it the video. Learn to perform exact match in Power Query like XLOOKUP, VLOOKUP in Excel.
The pbix file used in this can be downloaded from – https://1drv.ms/u/s!Akd5y6ruJhvhvwxUuHqOA1XAZ33u?e=8ZDAik