"Vlookup" in Power Bi DAx

[TheHack22]

Hi All,

Is there a way to simulate these Excel formulas in Power BI?
I'm automating a "Manual" Power BI System where all the computations were done in multiple MS Excel Sheets., then fed into Power BI I have manipulated data in the Query Editor, but don't know much about DAX Lookup Functions.
Found this function: on google "LookupValue" is there a way to nest an IF with LOOKUPVALUE?



a) =IF(B2="Default",VLOOKUP(G2,LU_AdUnit!AR:AT,3,FALSE),B2)
b) =IF(E2="Teads.tv","Out Stream",IF(C2="-",VLOOKUP(G2,LU_AdUnit!AM:AO,3,FALSE),IF(C2="(unknown)",VLOOKUP(G2,LU_AdUnit!AM:AO,3,FALSE),IF(C2="Unknown",VLOOKUP(G2,LU_AdUnit!AM:AO,3,FALSE),C2))))

Imran

 

[GraH]

Normally inside a data model, one does not need to perform any vlookup as this is handle via the relationships.
I would suggest you take the time to create a sound data model by normalizing and standardizing the data tables so it fits the DAX rules. Simply moving Excel to DAX without rethinking the solution sounds bad to be honest.

Now VLOOKUP in DAX is RELATED or RELATEDTABLE depending on the table you start from. Strongly recommend reading a few books on DAX before building solutions in PowerBI.