percent change by rows

Hi gaikwadaa123 ,

Please create it as a calculated measure, not a calculated column.

If you want to create a calculated column, try this:

Column =
Table[Diff]
    - CALCULATE (
        SUM ( Table[Diff] ),
        FILTER (
            Table,
            Table[MeasurementName] = EARLIER ( Table[MeasurementName] )
                && Table[Date] = EARLIER ( Table[Date] )
                && Table[hour]
                    = EARLIER ( Table[hour] ) - 1
        )
    )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.