Want to compare value with above value

DAX DAX Calculations
15

Hi @Anurag

Try below Calculated Column.

NewColumn =
VAR Sheet1name = Sheet1[Name ]
VAR Sheet1Period = Sheet1[period]
RETURN
IF (
MOD ( Sheet1Period, 3 ) = 0,
Sheet1[Value],
CALCULATE (
MAX ( Sheet1[Value] ),
FILTER (
sheet1,
Sheet1[period]
= ( QUOTIENT ( Sheet1Period, 3 ) + 1 ) * 3
&& Sheet1[Name ] = Sheet1name
)
)
)

Let me know if this doesn’t help or any other help is needed.

Thanks
Ankit J