Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |