Lookupvalue within same column

Hi SidharthK16 ,

According to your description, you don't want the month to fixed. In my understanding, for each month, you just want to calculate the number of repeated RespondentID comparing with the previous month.

I create a sample.

Here I use number to display the month, if you haven't it like me, you can create one or a rank based on year-month is also OK. Here's my solution, create a calculated column.

Column =
IF (
    COUNTROWS (
        FILTER (
            'Table',
            'Table'[Month]
                = EARLIER ( 'Table'[Month] ) - 1
                && 'Table'[Repondent Id] = EARLIER ( 'Table'[Repondent Id] )
        )
    ) > 0,
    1,
    0
)

Get the result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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