Forum Discussion
Use value in table1 to pull through value from custom field in table 2 (VLOOKUP in Excel equivalent?
I'm trying to learn PowerBI and some of the things I took for granted in Excel seem to be extremely problematic in PowerBI! :( I have two tables UNITCOMP and LAMPS UNITCOMP lists all of the st...
Greg_Deckler
Community Champion
Community ChampionSample data is very helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, LOOKUPVALUE is a possible replacement for VLOOKUP as well as a CALCULATE with a RELATED or RELATEDTABLE function potentially.