cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
malcolmholly10
Regular Visitor

Abbreviated month values not recognized as dates

Hello, 

 

I am trying to convert the data type for a month field to a "date" data type when it currently is being read by Power BI as a "text" data type. The months in the dataset are abbreviated and that is why Power BI is not recognizing the values as months. Is there any way to alias the values so that Power Bi can recongize these fields as month names ? Or is there any other way to convert this month field to a "date" data type ?

 

Thanks,

 

Malcolm Hollingsworth

6 REPLIES 6
dedelman_clng
Super User II
Super User II

Hi @malcolmholly10 -

 

I know this is 2 years too late,but I found your post looking for the same answer myself.  I was able to do it as a calculated column with the following code:

 

//[FC Month] is JAN, FEB, etc
FCM = IF(Table[AmountType] = "Forecast", "1-" & Table[FC Month] & "-" & Table[Year])

 

This gave me the first day of the month in the given year. You can wrap MONTH() around the whole thing to convert the 3-letter abbreviation to an integer.

 

Hope this helps

David




Proud to be a Super User!




parry2k
Super User III
Super User III

Is it only abbreviated month and it is full date with abbreviated month? Your question is not very clear.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





It is not a full date, only the abbreviated month in the field

You have convert this field to a date, could you share sample fields you have in the source, and find out best way to apporach it. 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Query_Editor_Example_1.PNGQuery_Editor_Example_2.PNGSample_Data.PNG

 

It is only an abbreviated month. 

 

Example: Jan, Feb, Mar.etc

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors