Showing results for 
Search instead for 
Did you mean: 

Exact Match XLOOKUP/VLOOKUP in Power Query

Learn to perform exact match in Power Query like XLOOKUP, VLOOKUP in Excel.

The pbix file used in this can be downloaded from -!Akd5y6ruJhvhvwxUuHqOA1XAZ33u?e=8ZDAik



I don't think this exist in Power querry, this is DAX language in Power BI, Power querry don't have this formula in Excel. 

Hi Edwin,

This is Power Query only not DAX. In DAX, VLOOKUP/XLOOKUP is performed using RELATED/RELATEDTABLE.

Good one



What is your favorite Power BI feature release for September 2023?