Forum Discussion
Check duplicate in another table
Hello guys, I'm trying to create a custom column in my 'investigation' table. I want that this new column tells me if there are some duplicates ERP number in my 'source' table matching with ERP n...
See this formula:
#"Add Duplicate Check" = Table.AddColumn( #"Changed Type", "Duplicate Check", each let varCode = [Code], varColor = [Color] in if Table.RowCount( Table.SelectRows( #"Source Table", each [Code] = varCode and [Color] = varColor ) ) > 1 then true else false, type logical )My PBIX file is here. It looks in this table:
and finds duplicates as shown:
My bad, i can't provide pbix file for now but maybe with this schema, it will be more precise :
Thank you very much !
See this formula:
#"Add Duplicate Check" =
Table.AddColumn(
#"Changed Type",
"Duplicate Check",
each
let
varCode = [Code],
varColor = [Color]
in
if Table.RowCount(
Table.SelectRows(
#"Source Table", each [Code] = varCode and [Color] = varColor
)
) > 1
then true
else false,
type logical
)My PBIX file is here. It looks in this table:
and finds duplicates as shown:
Thanks a lot, it worked like a charm !
Great Anonymous . Glad to help out.