Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Vijay_A_Verma

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 - https://1drv.ms/u/s!Akd5y6ruJhvhvwxUuHqOA1XAZ33u?e=8ZDAik

 

Comments

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

@Vijay_A_Verma