Forum Discussion
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...
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.