Forum Discussion
Solved
Convert month formatted as text to date
I've imported a data set to Power BI Desktop that I do not have any control over (i.e. I can't go into the dataset itself and reformat it). The only "time stamp" the data set contains is a single col...
Not sure if this was the best way, but I went into PQ Editor and replaced each of the 12 separate values with the full month name and year (e.g. replace "Jan" with "January 2020"), and this enabled Power BI to recognize the values as dates when I tried to convert.
Not sure if this was the best way, but I went into PQ Editor and replaced each of the 12 separate values with the full month name and year (e.g. replace "Jan" with "January 2020"), and this enabled Power BI to recognize the values as dates when I tried to convert.