Forum Discussion

gaikwadaa123's avatar
gaikwadaa123
Icon for Helper II rankHelper 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 ...
  • 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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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
Icon for Helper II rankHelper 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 ?

 

 

  • gaikwadaa123's avatar
    gaikwadaa123
    Icon for Helper II rankHelper II
    4 years ago

    Did you check my reply?

     Can you help me?

     

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    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.

    • Icey's avatar
      Icey
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi gaikwadaa123 ,

       

      Can this work?

       

      Best Regards,

      Icey

      • gaikwadaa123's avatar
        gaikwadaa123
        Icon for Helper II rankHelper II
        4 years ago

         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: