Forum Discussion

timbourdois's avatar
timbourdois
Frequent Visitor
5 years ago
Solved

Conditional duplicate check

Hi all...   I'm trying to use a conditional column (or power query) to check for duplicate values in one column and validate they belong to the same product (match) in a second column).  I'm close,...
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, timbourdois 

     

    Based on your desciption, I created data to reproduce your scenario. The pbix file is attached in the end.

    Table:

     

    You may create a custom column in Power Query with the following codes.

    let name=[Name],pathname=[Full Path Name],
tab=Table.SelectRows(#"Changed Type",each [Name]=name and[Full Path Name]=pathname)
in 
Table.RowCount(tab)

     

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.