Yoy % change with a column of dates and column of values

[apaicanada]

Hi,

My dataset looks something like this and I'm trying to figure out a formula which would calculate YoY change in these dates.

Record	Commodity	Value	Date
1	Oil	800	2010-01-01
2	Natural Gas	700	2010-01-01
3	Diesel	600	2010-01-01
4	Oil	900	2010-02-01
5	Natural Gas	650	2010-02-01
6	Diesel	200	2010-02-01

For example, if Oil was 800 on 2010-01-01 and 900 on 2011-01-01, then it could give a new column output of 0.111 (which is calculated by (900-800)/900).

Any and all help is appreciated, thank you!

[OllieClarke · Accepted solution]

Assuming that your data has exactly one value per commodity per year, then you could use this workflow:

It orders the data by commodity and year, and then works out the YoY using a multi-row formula grouped by commodity