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.

amitchandak's avatar
amitchandak
Super User
5 years ago

pjdsh , Create a new column like

if(isblank(countx(filter( Table, [TP ID] = earlier([TP ID]) && not(isblank([TP ID]))),[TP ID])) blank(), "Repeat ID")

pjdsh's avatar
pjdsh
Helper I
5 years ago

Hi amitchandak , i am getting data like this after applying the formula, i tried different possible ways to get the issue resolved. But couldnt get the solution. Can you please help.

ID                   TP ID                   Duplicate/Repeat
T3746798                                  Repeat ID
T3746794       V171990             Repeat ID
T3746772                                  Repeat ID
T3746771       V160880             Repeat ID
T3746755                                  Repeat ID
T3746754                                  Repeat ID
T3746753       V162650             Repeat ID
T3746706       V135213             Repeat ID
T3746708       V171990             Repeat ID
T3746695                                  Repeat ID
T3746694       V135213             Repeat ID