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 ...
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
kentyler
Solution Sage
Solution Sagecan 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
Thx Ken,
This solution indeed works, however I can't guess the year... This dataset runs across two year periods... so hardcoding the year isn't an option.
I am however going to keep this in mind and see if I can tweak it to work 🙂