Forum Discussion
Solved
If statement for adjacent rows
How do I get the result for the following in Power BI?
If(A2=A1, 0,1)
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])
1 Reply
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])