Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Is it only abbreviated month and it is full date with abbreviated month? Your question is not very clear.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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 only an abbreviated month.
Example: Jan, Feb, Mar.etc
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |