Forum Discussion

pjdsh's avatar
pjdsh
Helper I
5 years ago
Solved

Need Help in Repeated value

Need help in calculation to find out the repeated value in a period of 30 days and display the repeated value as 'Repeated' as shown in the sample data. I have to find out whether a TP ID is repeated...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi pjdsh ,

     

    Try this calculated column.

    Column =
VAR _COUNT =
    IF (
        [TP ID] <> BLANK (),
        CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[TP ID] ) )
    )
RETURN
    IF ( _COUNT > 1, "Repeat ID" )

     

     

    You can check more details from here.

     

     

     

    Best Regards,

    Stephen Tao

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

hi pjdsh - you can calculate the number of duplicates using the below logic - this is essentially counting the number of records with the value "Repeat ID" in the Duplicate column 

 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

pjdsh's avatar
pjdsh
Helper I
5 years ago

Hi Sumanth,

 

if you look at the data, second column TP ID has some duplicates, whenever there is a duplicate TPID, 'Repeated' is the value i will have to display in the third column 'Duplicate/Repeated' .

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hi pjdsh - Ok, so if I am understanding it correctly - you want the count to be calculated off the TP ID column is it? 

     

    Sorry was not clear on your last message. Thanks!