Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Vijay_A_Verma
Super User
‎01-07-2023 05:09 AM

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
‎01-11-2023 08:22 AM

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. 

0
Super User
‎01-12-2023 10:38 AM

Hi Edwin,

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

0
‎01-13-2023 03:53 AM

Good one

@Vijay_A_Verma 

 

0