- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
A table of multiple values was supplied where a single value was expected
I am trying to do like a vlookup in power bi with the lookupvalue funcion, because I need to create a collumn. But, I dont no the problem "A table of multiple values was supplied where a single value was expected".
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @Anonymous ,
The error message "A table of multiple values was supplied where a single value was expected" typically occurs when the LOOKUPVALUE function is returning more than one value for the given criteria. This can happen if there are duplicate values in the column being searched.
In your case, it means that there are multiple rows in 'Table (3)' where the condition 'Table (3)'[BNX-NUMERVIN] = 'table (1)'[BNXR-NRVIN] is met, and LOOKUPVALUE is unable to return a single value.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the help. I removed the duplicates values and it solved the error. Thanks again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @Anonymous ,
The error message "A table of multiple values was supplied where a single value was expected" typically occurs when the LOOKUPVALUE function is returning more than one value for the given criteria. This can happen if there are duplicate values in the column being searched.
In your case, it means that there are multiple rows in 'Table (3)' where the condition 'Table (3)'[BNX-NUMERVIN] = 'table (1)'[BNXR-NRVIN] is met, and LOOKUPVALUE is unable to return a single value.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-09-2023 06:13 AM | |||
04-20-2018 02:27 PM | |||
07-06-2023 06:23 PM | |||
12-06-2023 02:48 AM | |||
02-10-2022 08:38 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |