Identify duplicates

[rafterse]

All,

i have this table 

i want to identify the duplicates in column called skill by each "Name"

Output would need to look like this 

so if the person has two skills based on their position the low "Pay Tier " line calls out the higher "Pay Tier"

not fussed if i do it in power query or power bi. 

thanks in advance

[Irwan · Accepted solution]

hello @rafterse 

please check if this accomodate your need.

create a new calculated column with following DAX.

Duplicate Skill =
var _Value = 
MAXX(
    FILTER(
        'Table',
        'Table'[Name]=EARLIER('Table'[Name])&&
        'Table'[Skill]=EARLIER('Table'[Skill])&&
        'Table'[Pay Tier]<EARLIER('Table'[Pay Tier])
    ),
    'Table'[Pay Tier]
)
Return
IF(
    not ISBLANK(_Value),
    CONCATENATE("In Pay Tier ",_Value)
)

i assumed 'Pay Tier' is in the original table. Otherwise, please share how to define 'Pay Tier' column.

Hope this will help.

Thank you.

[rafterse]

how would i return the "Position" as well as the "Pay Teir" ?

[rafterse]

You ledgend. thanks so much it worked a treat