Forum Discussion
jas_power
Helper I
Helper ICalculated 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 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.
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.
1 Reply
jas_powerBased 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.