percent change by rows

[gaikwadaa123]

Hello, I need urgent help.

I have below table 

I would like to calculate the percent change of the 'Value' column for each Hour. 

So that 0 hour will have 0 as percent change  always and it will start from 0-1, 1-2,2-3 hour so on... till 23 hour and for each MeasureDate-copy and each MeasurementName 

Also please consider 'MeasureDate-copy' column and MeasurementName like (various Prducts), so that for each measurementname formula will calculate the percentage change from hour 0 to 23 for that sepecific day only. and so on. 

Pleas help me by using my column names. I really appriate any assistsnace. 

[amitchandak]

@gaikwadaa123 , Try a new measure like

sum(Table[Diff])- calculate(sum(Table[Diff]), filter(Table, Table[Date] = max(Table[Date]) && Table[hour] = max(Table[hour]]) -1 ))

[gaikwadaa123]

I am looking for the precentage change which should include devide statement. With your formula i can see result like below 

It is calculating same result for all rows. I want to see the percentage change for value column by each hour. 

Can you modify and check ?

[Icey · Accepted solution]

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.

[Icey]

Hi @gaikwadaa123 ,

Can this work?

Best Regards,

Icey

[gaikwadaa123]

 thank you it worked. I am looking for another same issue, 

I have two tables Difference and history ,

I would like to calculate the difference between Difference(actual) and History(value) colums based on the Hours and rate area. 

Here is the screenshot:

[gaikwadaa123]

Did you check my reply?

 Can you help me?