cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kumar11109 Member
Member

Taggin consecutive attempts as one

Dear All, 

 

I am trying to tag the same resources which have accessed consecutively by a group. The tag should remain the same, for ex. 

if resource 123 is accessed by group 098, 5 times consecutively for the first time then its tag should be 1 for all, similarly for group 876. But the next time the group accesses it then it should be 2. 

 

Sample data: Link

 

Please help me with this. 

 

 

Thank You, 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Taggin consecutive attempts as one

Hi @Kumar11109,

 

Add an index column under Query Editor first.

 

Then, please refer to below DAX formulas to new calculate columns.

flag =
IF (
    Test_1[Resource]
        <> CALCULATE (
            LASTNONBLANK ( Test_1[Resource], 1 ),
            FILTER ( Test_1, Test_1[Index] = EARLIER ( Test_1[Index] ) - 1 )
        )
        || Test_1[Group]
            <> CALCULATE (
                LASTNONBLANK ( Test_1[Group], 1 ),
                FILTER ( Test_1, Test_1[Index] = EARLIER ( Test_1[Index] ) - 1 )
            ),
    1,
    0
)

Tagging =
CALCULATE (
    SUM ( Test_1[flag] ),
    FILTER (
        ALLEXCEPT ( Test_1, Test_1[Resource], Test_1[Group] ),
        Test_1[Index] <= EARLIER ( Test_1[Index] )
    )
)

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Taggin consecutive attempts as one

Hi @Kumar11109,

 

Add an index column under Query Editor first.

 

Then, please refer to below DAX formulas to new calculate columns.

flag =
IF (
    Test_1[Resource]
        <> CALCULATE (
            LASTNONBLANK ( Test_1[Resource], 1 ),
            FILTER ( Test_1, Test_1[Index] = EARLIER ( Test_1[Index] ) - 1 )
        )
        || Test_1[Group]
            <> CALCULATE (
                LASTNONBLANK ( Test_1[Group], 1 ),
                FILTER ( Test_1, Test_1[Index] = EARLIER ( Test_1[Index] ) - 1 )
            ),
    1,
    0
)

Tagging =
CALCULATE (
    SUM ( Test_1[flag] ),
    FILTER (
        ALLEXCEPT ( Test_1, Test_1[Resource], Test_1[Group] ),
        Test_1[Index] <= EARLIER ( Test_1[Index] )
    )
)

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.