Forum Discussion

Nourhassan's avatar
Nourhassan
Icon for Helper I rankHelper I
4 years ago

Calculate Change by previous row value

Hello,   I need to calculate the load change hourly, so how the load is changed from time to time per percentage like the table below.    I have a table with a TIME (From 0 to 23) Column an...
Need Help
Tips and Tricks
Nourhassan's avatar
Nourhassan
Icon for Helper I rankHelper I
4 years ago

To know to which date the data is from. Maybe, later the dataset will be extended with other dates too. Then I can compare both dates with each other. 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

I added the date column.  Not sure what added value it provides. See attached.

 

 

  • Nourhassan's avatar
    Nourhassan
    Icon for Helper I rankHelper I
    4 years ago

    Thank you for your help. I really dont know what the problem is. This is my table below:

     

     

     

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      Is your table called 'Table' or something else?

      • Nourhassan's avatar
        Nourhassan
        Icon for Helper I rankHelper I
        4 years ago

        Something else, but I have been changed it also in the measure.