The finance team wants to compare revenue changes over time without relying only on absolute amounts.
The monthly_revenue table contains one revenue figure for each month. Use January 2025 as the fixed reference month, with an index value of 100. Express every month's revenue relative to that reference: a value of 120 means revenue was 20% higher than January 2025, while 90 means it was 10% lower.
Include every month in the table, including months before January 2025. Do not change the reference month as the report moves forward in time.
Ordering: Sort by month in ascending order.