Forum Discussion
RD_PowerBI31
3 years agoFrequent Visitor
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).
| NAME | DEPARTMENT | CODE |
| ADAMS | IT | 100 |
| JAMES | IT | 200 |
| ADAMS | IT | 300 |
| ADAMS | IT | 400 |
| JAMES | IT | 300 |
| CLARK | AE | 400 |
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.
| NAME | DEPARTMENT |
| ADAMS | IT |
| JAMES | IT |
| CLARK | AE |
2 Replies
- ppm1Solution Sage
Please see this article that shows one way to do that.
Understanding Group By Columns in Power BI - SQLBI
Pat
- RD_PowerBI31Frequent Visitor
Any workaournd please.