Forum Discussion

RD_PowerBI31's avatar
RD_PowerBI31
Frequent Visitor
3 years ago

Need display duplicate data

Hello,

I have data like this. The below records are not a duplicate. My requiremnt is if I remove the Code column I should see same number of records, it should not remove the duplicates (after removing the code column records will be duplicate right).

NAMEDEPARTMENTCODE
ADAMSIT100
JAMESIT200
ADAMSIT300
ADAMSIT400
JAMESIT300
CLARKAE400

I am trying to do with Calcuate (expression, allexcept(code) ) which is not working.

After removing ode column the below will be expected results, but my results should be same as above. I hope it is cleared.

NAMEDEPARTMENT
ADAMSIT
JAMESIT
CLARKAE