How to normalize months

[Anonymous]

Hi, 

I have a question which I would think has an easy answer. I have well production by month and I want to create a new column that normalizes month. For example, I want the first month of well production to be 1 instead of 9/30/2017 as in the example below. How can I do this? 

[Anonymous]

I should add to this that the next value in the column is a new well, so the equation would need to reset and normalize the months, starting with month 1 for 2/28/15 on PROPNUM 153768

[v-chuncz-msft · Accepted solution]

@Anonymous,

It seems that you may use RANKX Function to add a calculated column.

[Anonymous]

I should add to this that the next value in the column is a new well, so the equation would need to reset and normalize the months, starting with month 1 for 2/28/15 on PROPNUM 153768