Compare each row with the next

[aanchalshah18]

Hi,

I am to make a comparison of each row of an id to the next to check if the consecutive results are the same?

How can I do that? Thanks in advance.

[V-pazhen-msft]

@aanchalshah18 
Please check the sample, you can crate the column to check whether it repeats with last role, but you need a column of index or date or something else as the filter. 

Column = IF([Result]=CALCULATE(MAX([Result]),FILTER('Table',[Index]=EARLIER('Table'[Index])-1)),1,0)

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

[aanchalshah18]

Thanks for this..

In terms of me wanting to compare

Id      Missed/Not

1      Missed

1      Missed

1

1

So what I want to do is, take a percentage of missed ie. 2/4 = 50%

How can I do that?

[AllisonKennedy]

Are you saying this is still unsolved?
Try using divide and All (table[missed/not]) filter for the denominator. This should give you percent.

[amitchandak]

@aanchalshah18 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

You can refer how deal with this day vs last as column vs measure in this blog

https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[AllisonKennedy]

@aanchalshah18

What is the ultimate goal? You can do a remove duplicates in Power Query if you want to get rid of the same results, or you can also refer to this post to try it in Power Query if the DAX you've already been supplied doesn't work for your scenario: https://www.myonlinetraininghub.com/referencing-next-row-power-query

[harshnathani]

HI @aanchalshah18 ,

Create a column

Previous Value =
VAR _previousvalue =
    MAXX (
        FILTER (
            Table,
            Table[id]
                < EARLIER ( Table[id] )
        ),
        Table[Value]
    )
RETURN
    IF (
        Table[Value] = _previousvalue,
        1,
        0
    )

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[aanchalshah18]

Hi Thanks Harsh,

What would table[value] mean here?

[harshnathani]

Hi @aanchalshah18 ,

Table[Value]  is the Value you want to compare.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[harshnathani · Accepted solution]

Hello @aanchalshah18 ,

See if this blog helps you

https://community.powerbi.com/t5/Community-Blog/Getting-Previous-Values-in-Power-BI-Part-1/ba-p/1143...

Best regards
Harsh Nathani
Have I answered your question? Mark my position as a solution! Appreciate with a Kudos!! (Click the Thumbs button above)