cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dawn85
Frequent Visitor

Convert Month counter to month name

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_0-1619040132415.png

 

 

 

1 ACCEPTED SOLUTION
Dawn85
Frequent Visitor

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! 😊

 

Dawn85_0-1619103355419.png

 

View solution in original post

5 REPLIES 5
Dawn85
Frequent Visitor

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! 😊

 

Dawn85_0-1619103355419.png

 

View solution in original post

themistoklis
Super User II
Super User II

@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 

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

OK, so starting number is 201.

You just need to find out that it is a sequence

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors