duplicate data

[Delorito]

{"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

[danextian · Accepted solution]

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.