Forum Discussion
Duplicate records with same ID-using formula
Hi, I have a table like below where I want the id of the duplicate records to be same. Current Data Sno Name value 1 John 20 2 John ...
Another approach in DAX.
RANK_SNO = RANKX ( 'Table', CALCULATE ( MIN ( 'Table'[Sno] ), FILTER ( 'Table', EARLIER ( 'Table'[Name] ) = 'Table'[Name] ) ), , ASC, DENSE )
Another approach in DAX.
RANK_SNO =
RANKX (
'Table',
CALCULATE (
MIN ( 'Table'[Sno] ),
FILTER ( 'Table', EARLIER ( 'Table'[Name] ) = 'Table'[Name] )
),
,
ASC,
DENSE
)
Thanks Eric and Marcel , I have worked out both and works perfectly fine.
Eric_Zhang If I have the data without the S.no column and if I have the same Values for the same name in this case (John 20)would it be possible to acheive the same using RankX
, I used this but I am not getting the Correct output
Column = RANKX(Sheet1,
Sheet1[Name]
,
,ASC,Dense)
| Name | value |
| John | 20 |
| John | 20 |
| Jill | 40 |
| Kirk | 50 |
| Kirk | 60 |