Forum Discussion
Solved
Calculated Column - Lookup Value in Same Table Based on Multiple Conditions
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 p...
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.
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.