Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi ,
Is there any way we can identify duplicates based on single column, Although the values on different colums are different for same Person. Please check on below data.
Here employee Binay is having duplicates , since he is available in India and Malaysia although his other fields are different i.e differnt projects he is working.
So i need a column to identify whether he is working on multiple projects and if he is return Yes, else NO , the unique identifier is Emp no. Can you please help on how to resolve this.
Emp no | Name | country | phone | project | Validation | |
121 | Binay | India | 11221122 | asd@asd.com | A | Yes |
121 | Binay | Malaysia | 33321131 | asd@ad.com | B | Yes |
111 | jethwa | singapore | 23332 | add@aaa.com | C | Yes |
111 | jethwa | india | 22222 | aaaa@ase.com | D | Yes |
112 | dfd | thailand | 3331 | ad2@sa.com | D | No |
114 | sdf | Indonesia | 333 | 23@d.com | D | No |
Thanks,
Binay
Solved! Go to Solution.
Hi,
Regards,
Prakash M
If you want to use Calculated column, Try below Dax
Validation =
Var Emp = [Emp No]
var counts = CALCULATE(
COUNTROWS(EmployeeTable),
ALL(EmployeeTable),
EmployeeTable[Emp No] = Emp
)
RETURN
IF(counts>1,"YES","NO")
Hi,
Regards,
Prakash M
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |