Forum Discussion
Lookupvalue issue
Good day all,
Just need some help with the below Lookupvalue issue, I have two tables
DOP-055 1 table holds the result I will like to bring over to table DOP-055 but I get the below error ☹️
If anyone could help that would be great thank you,
Regards
Snowy
Hi Snowy34 ,
You can create the following calculated column to check if there is a duplicate value in 'DOP-055 1' [Delivery No]:
Duplicate check = CALCULATE ( COUNT ( 'DOP-055 1'[Delivery No] ), ALLEXCEPT ( 'DOP-055 1', 'DOP-055 1'[Delivery No] ) )You may need to use FIRSTNONBLANK / LASTNONBLANK, here are some similar resources that might help:
LOOKUPVALUE - "A table of multiple values was supplied where a single value was expected"
Dealing with Duplicates “A Table of Multiple Values was supplied” using DAX
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Snowy34 ,
You can create the following calculated column to check if there is a duplicate value in 'DOP-055 1' [Delivery No]:
Duplicate check = CALCULATE ( COUNT ( 'DOP-055 1'[Delivery No] ), ALLEXCEPT ( 'DOP-055 1', 'DOP-055 1'[Delivery No] ) )You may need to use FIRSTNONBLANK / LASTNONBLANK, here are some similar resources that might help:
LOOKUPVALUE - "A table of multiple values was supplied where a single value was expected"
Dealing with Duplicates “A Table of Multiple Values was supplied” using DAX
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
