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
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.
This is Power Query only not DAX. In DAX, VLOOKUP/XLOOKUP is performed using RELATED/RELATEDTABLE.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.