Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I'm trying to lookup value (list prise) in one input table:
and merge it with the following table
to get the following resul table (list price is the same ragardless the date)
However, Lookupvalue formula returns an error "A table with multiple values was returned when a single value was expected".
Any idea what causes the error and how to solve it?
Thank you!
Solved! Go to Solution.
@Anonymous
Check your 1st table for duplicate values in product column. you try the following as well:
ListPrice =
MAXX(
FILTER(
table-1,
table-1[product]=EARLIER(table-2[product])
),
table-1[List Price]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Anonymous ,
What formula did you use?
Here is an example for a measure:
#lookupLP =
LOOKUPVALUE(InputTable[LP], InputTable[Product], MAX(FollowingTable[Product]))
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
@Anonymous
Check your 1st table for duplicate values in product column. you try the following as well:
ListPrice =
MAXX(
FILTER(
table-1,
table-1[product]=EARLIER(table-2[product])
),
table-1[List Price]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hey @Anonymous ,
did you create it as a calculated column?
Try the following calculated column:
List Price = LOOKUPVALUE( 'Product'[List price], 'Product'[Product], Retail[Product] )
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
66 |
User | Count |
---|---|
115 | |
103 | |
93 | |
64 | |
61 |