Forum Discussion

Hellozooey's avatar
Hellozooey
New Member
3 years ago

Removing duplicates

 

I am new to excel and power bi

i made three excel queries and I need to link them all together and manage the relationships. 

I keep getting duplicates and need help trying to figure out how to only keep the values I need not the excess.

 

For example IP camera the true values from excel are QTY 4 Carton 4 Pallet 1

 

i don't need all the excess rows 

Need Help
Tutorial Requests

2 Replies

    • Hellozooey's avatar
      Hellozooey
      New Member
      3 years ago

      Hi greg

       

      the value from the quantity is pulling from one excel work book 

       

      while the value of carton and pallet is pulling from another

       

      the value for carton and pallet for IP camera on the workbook is  4 and 1

       

      not sure why it created duplicate rows and extra numbers