Forum Discussion
Remove duplicates keeping different values
- Hi Crobelo,
On the query editor select all the columns with duplicate values that you want to remove and then remive duplicate.
Check the link below.
https://support.office.com/en-us/article/remove-duplicates-power-query-d9cffc69-dc5d-4d94-8b66-72779688874d
Hey Crobelo
MFelix is correct, you will need to go into Query Editor and select the column that has the unique identifier that you wish to keep a single line for and then select "Remove Duplicates".
If you need the total for Div_Fis & Calz_Fis since they have different numbers for each line then you will have to create a measure using a sumif formula: https://community.powerbi.com/t5/Desktop/Sumif-in-Power-BI/td-p/15457
If you need each of those lines combined in some way you will have to use measures. If you just need one of those lines you can remove duplicates. If you do not have a unique identifier column in the original excel file then I recommend making one like in this article: https://exceljet.net/formula/extract-all-matches-with-helper-column