Remove duplicates on multiple columns -#5 (M)agic (M)ondays

I've been beating my head for an hour trying to figure this out and now I'm smacking my head because this was so simple. Thank you Ruth!!

Yet again you have resolved my issue in minutes Ruth. THANK YOU !!!!!

This was so helpful!! Thank you! PowerBI Magic!

Simple but efficient and still relevant ❤

I tried this earlier before watching this video and I wasn't sure of this..Thank you..now I understood the logic

When you remove the duplicate columns will it sum up straight away?

Dropping duplicates option doesn't show up when I perform crt+shift and right click. However, if one column is selected the option becomes available. I'm on Version: 2.87.1061.0 64-bit (November, 2020)

This video pulled us out of a two week long thorn in our spine with our customer's powerbi model that consumes our data. Awesome, thank you so much. Excellent detailed example of the source of the problem, I ended up solving the problem upstream in SQL but goddamn am I so so happy to understand the root cause here. That was the real gold in this video. Cheers.

Amazing clean up possibility for bad data of which the Business people always say it does not occur:)

This is just the solution I need for the multiple values error. Thanks a mil

Hi Ruth can you please share the address of Microsoft page you used to see the formula.

Its (M)agic :)

Thanks for the Shout Out Ruth :). excited to see you live tomorrow :)

Thanks for the Unique Records on two columns : )

So simple! Great tip