Forum Discussion
How to change text to date format
Hi guys,
Power BI neewbie here ... and I am in need of some help. I have a dataset with a "month" column which has short month names (jan, feb, mar, apr, may etc...) ONLY as values. These are in Text format and I need to change them to date format.
What is the best way to get this done? I can't seem to just change the type to date because it will give me errors...
Thx in advance for all help!!
can you guess the year ?
I've created a calculated column which has a year hard coded, it combines the year with the text month name and transforms them into a date
Every time I answer a question I learn something
I'm a personal Power BI trainer
4 Replies
- kentyler
Solution Sage
Do you also have a column that tells what year you are in ?
- kentyler
can you guess the year ?
I've created a calculated column which has a year hard coded, it combines the year with the text month name and transforms them into a date
Every time I answer a question I learn something
I'm a personal Power BI trainer