Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Sgb1201
Helper I
Helper I

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: 

Sgb1201_0-1661849576979.png

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Sgb1201 , 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

View solution in original post

2 REPLIES 2
Sgb1201
Helper I
Helper I

@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! 

amitchandak
Super User
Super User

@Sgb1201 , 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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Users online (557)