Convert Month counter to month name

[Dawn85]

I have Power BI connected to a live database. In the data I noticed the individual who set it up did a day counter and a Month Counter. For example today is 4585 and the month is 214 (April).

I have no clue how these numbers are calculated, all I know is my invoice data is governed by this month counter instead of a Month Name: 

213 - March

214 - April

215 - May

and so on.

Every row of data has this counter. Is there a way I can change these numbers or define them in the Power Query Editor? Maybe define a starting point?

I am very new to Power BI and I have never seen this before myself and don't know why the original individual programmed it this way but unfortunately they are no longer with us.

Any help would be greatly appreciated!

[Dawn85 · Accepted solution]

I created a new Query that ill be able to make a relationship with. I believe this should work. If anyone has an easier way though I would not object to it. Thank you all again! 😊

[themistoklis]

@Dawn85 

It seems that these are incremental numbers starting from the first month/day in the dataset

These can be used in cases where someone would like to compare current vs previous month or to sort the date periods

If you want to find out that these are actually sequences try to sort the months or days (ascending order) and check whether the first month has the number 1 

[Dawn85]

It starts at 201, That is when this system went live (May 2020)

[themistoklis]

OK, so starting number is 201.

You just need to find out that it is a sequence

[Dawn85]

Should I create a number sequence/Month reference table in excel and just link that? Would that be the most efficient way?