Calculated Column - Lookup Value in Same Table Based on Multiple Conditions

[jas_power]

I have a table where I need to create a calulated column to determine the value from the main product for each row.

I want to lookup the value when the geoId and refPer matches and the prodId = 2. So for each product id in the table, I want to show the value for prodId 2 for the same refPer and geoId.

[jas_power · Accepted solution]

Based on the response by @MG86  in this thread (Solved: LookupValue with Filter - Microsoft Power BI Community) I added a calculated column that did the trick.

value2 = LOOKUPVALUE(I_data[value], I_data[geoId], I_data[geoId], I_data[refPer], I_data[refPer], I_data[prodId], 2)

Thank you @MG86 for such an elegant solution.