I have the need to see how long prices have been at the same value
So I may have a table
Month Price
1. Jan 5.50
2. Feb 5.50
3. Mar 5.50
4. Apr 6.00
5. May 6.00
6. Jun 6.00
7. Jul 6.00
8. Aug 6.00
So in this above example we can see that the price has been at 6.00 for the last 5 months. I want to be able to calculate this figure for hundreds of different company / product combinations but I'm struggling to even begin.
I've thought about doing a big if statement saying something along the lines of
If current price = price 12 months ago then 12,
if current price = price 11 months ago then 11,
......etc etc
but this gets very big very quickly
Any thoughts?
Ultimately I want
Month Value of the last sales point (8)
-
Smallest month value where price = current price (4)
+1
= 5
