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.
Hello,
I need your help please.
I can't use the lookUpValue or RelatedTable function to get information from another table.
I mean there is the 'Sales' table and the 'Obj' table and I would like to take from the 'Sales' table the column of smartphone models (string) and incorporate it in the 'Obj' table by using their IDs present in each table.
My data model
It displays this message:
"A table of multiple values was supplied where a single value was expected"
According to the error message, it found multiple smartphone model values for an ID in the Sales table. In your data, does an ID only have one smartphone model value or it may have multiple values? If it has multiple values, you will see this error.
Regards,
Community Support Team _ Jing
Hey Thank you for you help After 4 different attempts, the only one which seems to work is : But, there is a mistake : in fact, some smartphone models are missing
@enicolasAtmosp , depending on the relation between tables there are 4 ways , refer to my video on that
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |