Find Duplicate Values in Dimension Tables

A common problem is duplicate values in the dimension tables while creating a one to many relationship. In this video I'll show you 3 ways to find duplicate values in your dimension tables.

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

---
► Artist Attribution
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Official After The Fall YouTube Channel Below
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)

[cristian.angyal]

When I saw the title my initial idea was to go to Power Query and Group By as I could also remove the duplicates there. Didn’t even consider DAX 😜 … but these three methods are also working fine and could be used to spot duplicates 😉.
Great video Chandeep. Thank you for sharing it!

[mariaen]

What an awesome tip! My favorite tip was the dragging of the fieldname twice. Thank you for sharing!

[Shib_ghosh]

Thank you so much for sharing these tricks.. I always copy the entire table to excel then run countifs formula to check the duplicate values.. Now i don't need do that anymore.. Great help.. 🙏🙏

[wayneedmondson]

Awesome examples and techniques! Thanks Chandeep. Thumbs up!!

[hassanny]

Brilliant!!! Searched this for 3 weeks

[zscbmyt]

you just saved my school project, thank you <3

[vazik_cze]

Hello Chandeep, thanks for your lessons.

I did this via measure for my tasks:

Find Duplicates in Column=
VAR ProductsCount =
COUNT ( Products[Product Code] )
RETURN
IF ( ProductsCount > 1; ProductsCount; BLANK () )

[IvanCortinas_ES]

Excellent tutorial. Thank you Chandeep.

[ramonillarramendi]

Great video. Never thought of Dax, .Would have gone directly to PQ.

[rahulkumaraasu]

Hi I have duplicate product in a column I want that if product a is available two times then output should be 1 and 2 not only 2 against product a basically I want numbering on products

[excelangola]

Hi Chandeep hope you are great.
I want to create a Dim table from a fact table, the probkem is that I can't define the unit price for each product line, because There are duplicate values in the fact table. Can you make a video with this solution please? Salute from Angola

[anusakhan]

Simple and fast way to figure out duplicates - Asghar 😎

[shivasai]

WHAT IF I DONT want to delete the duplicates but just want to do for some visuals, how can i do it in

[damn]

What about, if it's not a true duplicate. For example I have Duplicate product ID, but the product is in 2 warehouse. And the warehouse is in another column. Or I have more than one transaction on a product.

[sokevin]

How to check if the items shown up on table twice or more in the same day and same store? Or make an column that counting the repeating?

[SamehRSameh]

I Need add other condition depend on date (month ), how can i do ?

[eslamfahmy]

Can you work step by step as i missed all entire data