index and match function

[gchobiz]

how can i get index value for the data below? in excel, it will be simple index and match function. 

i am not sure what is the best way to handle this in PowerBI. 

I saw similar questions, but could not really understand, so giving a shot with my specific examples. 

thanks, 

[jbwtp]

Hi @gchobiz,

this depends on what actually you want this for.

The most simplistic I guess would be adding an index column and then merge the tables and exctract the index column to where you need the MATCH.

Cheers,

John