Forum Discussion
Solved
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 ...
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.
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.
You ledgend. thanks so much it worked a treat