Forum Discussion
Identify duplicates
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
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.
3 Replies
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.
