Had an oddity that perhaps someone can explain.
I used Power Query to eliminate (I thought) duplicates in the data source for the column GHX Mfr Part #.
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [#"GHX Mfr Part #"] <> null and [#"GHX Mfr Part #"] <> ""),
#"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"GHX Mfr Part #", Order.Ascending}}),
#"Removed Duplicates" = Table.Distinct(#"Sorted Rows", {"GHX Mfr Part #"})
I go into the Power Pivot data model and attempt to link tables with GHX Mfr Part # as one of the columns, but got the dreaded "The relationship cannot be created because each column contains duplicate values..."
Is there some better way to eliminate duplicates that Power Pivot will recognize?
I used Power Query to eliminate (I thought) duplicates in the data source for the column GHX Mfr Part #.
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [#"GHX Mfr Part #"] <> null and [#"GHX Mfr Part #"] <> ""),
#"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"GHX Mfr Part #", Order.Ascending}}),
#"Removed Duplicates" = Table.Distinct(#"Sorted Rows", {"GHX Mfr Part #"})
I go into the Power Pivot data model and attempt to link tables with GHX Mfr Part # as one of the columns, but got the dreaded "The relationship cannot be created because each column contains duplicate values..."
Is there some better way to eliminate duplicates that Power Pivot will recognize?