Forum Discussion
Helper IHow to find duplicate values count by matching 2 columns
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.
Helper IHave 3 source files
source file 1 with below columns having duplicates
Mobile. Month UTM
xxx. 01 Apr. Paid
xxx. 02 Apr. organic
yyy. 01 Apr. Paid
source file 2
Mobile. Month UTM
xxx. 01 May. Paid
xxx. 02 May. organic
yyy. 02 May. Organic
zzz 03 May. Organic
currently I am fetching files from the folde merging it and want to remove duplicates in respective month how're getting below result
Mobile. Month UTM
xxx. 01 Apr. Paid
yyy 01 Apr. Paid
zzz. 03 May. Organic
however the desired out come in data set is below
Mobile. Month UTM
xxx. 01 Apr. Paid
yyy 01 Apr. Paid
xxx. 01 May. Paid
yyy. 02 May. Organic
zzz. 03 May. Organic
Super Usersee my video
https://1drv.ms/v/s!AiUZ0Ws7G26RiSevPLIZdSe5rRcO?e=2fJygq
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RiSajyIOa-MdcvsaJ?e=R37ipK
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.
- vanik85
Thanks for your help!