Find and tag duplicate values in Power Query

Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @[e-mail]
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

[@kelleyn1872]

You’re so helpful. Thank you!!

[@cocoville9289]

Thank you! It’s very helpful

[@Nalaka-Wanniarachchi]

Nice and easy trick.Another allrows use case..

[@ppillo3349]

Wonderfulloso

[@pedroportella3134]

Nice trick

[@abhijeetghosh27]

WoW.. Lovely 😀😀👌

[@tracy2919]

❤

[@gennarocimmino]

👍👍

[@fe_nicks]

Hmmm.. But it tags the original value as duplicate as well.. Guess only 2/3 'A's has to be marked as duplicates).. Otherwise you risk to loose original data by accidental removal)))..

[@1mrkleks]

At 0:49 you have values grouped and tagged. You can add more aggregations to "group by" done earlier (0:25) like sum. You didn't loose anything, or am I missing something?

[@CurbalEN]

If you just want to remove the duplicates (rather than find them) just right click and pick remove duplicates