Solved: Re: duplicate data

Delorito · ‎11-27-2023

{"I0021", "FP1", "JOÃO"},

{"I0021", "FP2", "JOÃO"},

{"I0021", "LC2", "JOÃO"},

{"I0021", "LC3", "JOÃO"},

{"I0021", "LC1", "VITO"},

{"I0021", "LC2", "VITO"},

{"I0021", "LCK", "VITO"},

{"I0021", "LC1", "VITO"},

{"I0021", "CK", "DELO"},

{"I0021", "LC1", "DELO"},

{"I0021", "LC3", "DELO"},

{"I0021", "CK", "DELO"},

{"I0021", "FP3", "GF"},

{"I0021", "FP1", "GF"},

{"I0021", "LC1", "GF"},

{"I0021", "FP3", "GF"}

Preciso remover valores duplicados, mas sem afetar a formação da planilha com código dax

danextian · ‎11-27-2023

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.

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

danextian · ‎11-27-2023

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.

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.