Forum Discussion
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", "LC3", "JOÃO"},
{"I0021", "LC1", "VITO"},
{"I0021", "LC2", "VITO"},
{"I0021", "LC2", "VITO"},
{"I0021", "LCK", "VITO"},
{"I0021", "LCK", "VITO"},
{"I0021", "LC1", "VITO"},
{"I0021", "CK", "DELO"},
{"I0021", "LC1", "DELO"},
{"I0021", "LC1", "DELO"},
{"I0021", "LC3", "DELO"},
{"I0021", "LC3", "DELO"},
{"I0021", "CK", "DELO"},
{"I0021", "FP3", "GF"},
{"I0021", "FP1", "GF"},
{"I0021", "FP1", "GF"},
{"I0021", "LC1", "GF"},
{"I0021", "LC1", "GF"},
{"I0021", "FP3", "GF"}
Preciso remover valores duplicados, mas sem afetar a formação da planilha com código dax
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.
1 Reply
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.