Remove Duplicates Issue

[happyhungarian]

Hi All, I'm running the following power query but the results are leaving a few duplicate "Unique ID"s. Can you tell me where I am going wrong with this? What I was hoping it would do is first filter out any records where the "Total" was not >=0 and then, with the remaining records, filter out any duplicate Unique IDs (even if the duplicate Unique ID had a different "Total". Hope that makes sense.

let
Source = Excel.CurrentWorkbook(){[Name="Prior"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Status", type text}, {"Company", type text}, {"Customer", type text}, {"Total", type number}, {"Unique ID", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Status", "Company", "Customer"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [Total] >= 0),
#"Removed Duplicates" = Table.Distinct(#"Filtered Rows", {"Unique ID"})
in
#"Removed Duplicates"

 

[ExcelToDAX]

Are there any spaces that maybe you can't see? Maybe use the Text.Trim function

 

[happyhungarian]

Are there any spaces that maybe you can't see? Maybe use the Text.Trim function

That was my first thought as well but confirmed there are no spaces and that they are identical

 

[happyhungarian]

I did notice that the duplicate records had different capitalization of letters but when I do "Record"="Record" i get a "True" answer. I wouldn't think that Remove Duplicates would take capitalization into account but maybe that's it?

 

[ExcelToDAX]

Yes that it is it. use the function Text.Upper or Text.Lower and then remove duplicates

 

[happyhungarian]

Yes that it is it. use the function Text.Upper or Text.Lower and then remove duplicates

That worked! Thanks