Forum Discussion

gaikwadaa123's avatar
gaikwadaa123
Helper II
4 years ago
Solved

percent change by rows

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. 

  • Icey's avatar
    Icey
    4 years ago

    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.

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      gaikwadaa123
      Helper II
      4 years ago

      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 ?