VLOOKUP in Power BI

[deniseb]

Hello, Maybe someone can help me with my problem.

I have two tables (values, key). In the table values there are several columns with different values. The table key shows which column must be used for the row. The remaining values are irrelevant (see picture). This value should be in a separate field. In Excel we have a VLOOKUP formula for this. It's a little complicated to explain, but I hope you understand it anyway.

Thank you for your help

table value

[ryan_mayu]

@deniseb 

maybe you can try to use unpivot 

Unpivot columns - Power Query | Microsoft Docs

then use lookupvalue

LOOKUPVALUE function (DAX) - DAX | Microsoft Docs