Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • kentyler's avatar
    kentyler
    6 years ago

    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 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

No unfortunately not.. I literally only have this column to work with...

kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
6 years ago

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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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 🙂