Forum Discussion
Helper IHow to find duplicate values count by matching 2 columns
Hi
I have been trying to identity duplicate values by matching 2 or more columns in power bi
e.g
Month. Mobile number insertion date UTM
Apr. xxx. 1/04/23. Organic
Apr. xxx. 2/04/23. Paid
Apr. yyy. 3//04/23. Organic
May. zzz. 1/05/23. Organic
May. zzz. 5/05/23. Paid
expected outcome
Mobile number Count Month. First insertion date
xxx. 2. Apr. 1/04/23
zzz. 2. May. 1/05/23
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RiR5EgcMrD5D2XNCX?e=cfB8GX
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
see my video
https://1drv.ms/v/s!AiUZ0Ws7G26RiSevPLIZdSe5rRcO?e=2fJygq
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RiSajyIOa-MdcvsaJ?e=R37ipKIf this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
7 Replies
- Ahmedx
Super User
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RiR5EgcMrD5D2XNCX?e=cfB8GX
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
vanik85Thanks! Big help!
have a follow up question which will explain
incase we wish to remove the duplicates at the time of data consolidation
e.g
source file 1 Mobile number
file 1. xxx
file 1. yyy
file 2. zzz
file 2. zzz
Duplicate to be removed by checking values in file 1 and duplicate mobile number to be dropped post the first insertion date
- Ahmedx
I don't understand, please explain again with an example.