If statement for adjacent rows

[aksharitha22]

How do I get the result for the following in Power BI?

If(A2=A1, 0,1)

[amitchandak · Accepted solution]

@aksharitha22 , For that you need an index column -https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

Assume you have column A

[A] - maxx(filter(Table, [Index] = earlier([Index])-1), [A])