Forum Discussion
Calculate Change by previous row value
I have these two tables below:
I have a Report with a new Calculation, named "Expected Demand" which multiply the "Load Change" from Table DailyLoad with "Switch_MW" from Table ENS. Both tables are not in relationship. I don't know how to handle this.
| Expected Demand (MW) |
| Switch MW*Load change % |
The Load change in the Calculation "Expected Demand" has to be chosen from the correct timezone in Table dailyload.
It is more clear now?
The new column has to be added to ENS Table.
Either you find a relationship (a column that matches between the tables) or you use LOOKUPVALUE() if a relationship cannot be determined.
I don't have any column that can build a relationship between the tables, so I need to use LOOKUPVALUE(). Can you help me with how to use it in this case?
I have no expertise in using LOOKUPVALUE. I try to avoid using that function, and prefer to have a solid data model to work with.
