Solved: Re: How to normalize months

Anonymous · ‎02-14-2018

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?

v-chuncz-msft · ‎02-16-2018

@Anonymous,

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous · ‎02-14-2018

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 · ‎02-16-2018

@Anonymous,

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎02-14-2018

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

How to normalize months

Helpful resources

Power BI Monthly Update - April 2025

NEW! Community Notebooks Gallery

Fabric Community Update - April 2025

How to Get Your Question Answered Quickly

Enter to win a FREE Fabric certification exam voucher