Forum Discussion
Delorito
2 years agoNew Member
duplicate data
{"I0021", "FP1", "JOÃO"}, {"I0021", "FP1", "JOÃO"}, {"I0021", "FP2", "JOÃO"}, {"I0021", "FP2", "JOÃO"}, {"I0021", "LC2", "JOÃO"}, {"I0021", "LC2", "JOÃO"}, {"I0021", "LC3", "JOÃO"}, {"I0021...
- 2 years ago
Hi Delorito ,
You can create calculated summary table in DAX using DISTINCT or you can remove duplicates in Power Query (https://excelchamps.com/power-query/remove-duplicates/ ) If this isnt what you're looking for, please elaborate your use case and provide your expected result.
danextian
2 years agoSuper User
Hi Delorito ,
You can create calculated summary table in DAX using DISTINCT or you can remove duplicates in Power Query (https://excelchamps.com/power-query/remove-duplicates/ ) If this isnt what you're looking for, please elaborate your use case and provide your expected result.