Forum Discussion
Using lookupvalue error because of duplicates
Hey,
I'm using a lookupvalue function in one of my columns to get values from another table in my dataset, but I'm getting an error. I think this is because of duplicates in the item value collumn:
I've tried removing duplicates in the query editor, but it leaves the above "duplicates", possibly because of the two different values in the third column. Is there an easy way (either in DAX or M) to make it simply choose the first value (in the third column) and delete the second as it is redundant -- and thereby removing the duplicate item values (first column?)
Best regards,
Sgb
Anonymous , You can try like , a new column in table 1
Maxx(filter(Table2, Table1[ID] = Table2 [ID] ), Table2[Column])
Sumx(filter(Table2, Table1[ID] = Table2 [ID] ), Table2[Value])
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
2 Replies
- amitchandak
Super User
Anonymous , You can try like , a new column in table 1
Maxx(filter(Table2, Table1[ID] = Table2 [ID] ), Table2[Column])
Sumx(filter(Table2, Table1[ID] = Table2 [ID] ), Table2[Value])
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 amitchandak , I got it to work with the first part (Maxx(filter(Table2, Table1[ID] = Table2 [ID] ), Table2[Column])), where the Table2[Column] is the first column (item number), right?
The second part does not work -- what does it do exactly?
Either way, it seems to work correctly without the second part anyways, thanks alot for the help!