Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.


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 November 2023?