My primary database has duplicate values

Question

My company's primary database, containing production jobs, has duplicates because jobs must move between production plants.

How can I use this table in Power Pivot without using an Excel bridge table to manually remove duplicates?

(I am new to both Power Pivot and Power BI)

Answer 1

Hi,

I suggest you post this issue to Power BI forum:

https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Besides, for better analyze your request, it's better provide a simple sample.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---