Divide values within column to create new column

Hi,

I'm quite new to Power BI. I need help with a piece of logic I used to implement in QlikView. It is a memory-intensive operation, and we were thinking of executing this piece in Power BI. Our data set looks like the blue cells below.

There are 3 columns: Series_ID, Date and Index Value. Every series ID has an entry for every month for a certain period (here, 2013-2018). It receives an index value for each month (sometimes, it may not). The grey section represents the columns we need to add to the table.

The column Jan|2013 represents the index value rebased to Jan 2013, i.e. for every series ID-month combination, the index value is divided by the index value for that series ID in Jan 2013. This is done for every month until May 2018, i.e. I need to create a new column for every month in the data set.

For example, in the first row, 10/10 = 1. Hence Jan|2013 has 1.

In the second row, 14.5/10 = 1.45. Hence Jan|2013 has 1.45. And so on.

Ideas?

Thanks,

Saurabh