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!
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.. 🙏🙏
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 () )
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
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
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.
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
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!
What an awesome tip! My favorite tip was the dragging of the fieldname twice. Thank you for sharing!
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.. 🙏🙏
you just saved my school project, thank you
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 () )
Brilliant!!! Searched this for 3 weeks
Awesome examples and techniques! Thanks Chandeep. Thumbs up!!
Nice and crystal clear definition.
Excellent tutorial. Thank you Chandeep.
Great video. Never thought of Dax,.Would have gone directly to PQ.
Thanks man 🎉
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?
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
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
I Need add other condition depend on date (month ) , how can i do ?
Simple and fast way to figure out duplicates - Asghar 😎
WHAT IF I DONT want to delete the duplicates but just want to do for some visuals , how can i do it in DAX?????
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.
Can you work step by step as i missed all entire data