How to replicate Vlookup in power BI ?

[agragesh123]

Hi! I have two different tables each very important in it own datapoint that they throw. The thing is Related will not work in this case becuase are absolutely no coloumn on whom i can remove duplicate to link with the other coloumn.The table is as follows:

I hve the d list also with a lot of duplicates but in EX I do it as vlookup(d,sheet name[col],1,0) something like this so that in the end i can count the number of times the code repeats in the second file

[Greg_Deckler]

There is a LOOKUP function in DAX:

https://msdn.microsoft.com/en-us/library/gg492170.aspx

Also, you can check out my article here as well, which has some various methods of replicating lookup functionality:

https://community.powerbi.com/t5/Community-Blog/Good-Ol-VLOOKUP-The-Ultimate-Guide-to-Lookups-in-Pow...

[agragesh123]

my both fields are not having any unique columns they both have a lot of duplicate values. thus am not able to use the related function. is there any other way?

[Anonymous]

Maybe you can create a key column with two other columns using the concatenate formula.