Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Can't convert text to date

Hi guys, I am newbie in powerbi  I have this column with dates like '20180101' which is supposed to be 2018-01-01.  I tried converting it in the modelling but received this error message.   "...
Need Help
Show and Tell
Tips and Tricks
  • DoubleJ's avatar
    DoubleJ
    7 years ago

    That's interesting because I was able to transform the exact same string to a date using the Power BI Transform functionality.

     

    However, you could add a calculated column that does the transformation

     

    DateColumn = 
DATE(
    LEFT('Table'[DateString],4,
    MID('Table'[DateString],5,2),
    RIGHT('Table'[DateString],2))

    You have to make sure that the string always has the same format YYYYMMDD.

     

    Hope this helps

    JJ

     

Qmars007's avatar
Qmars007
Frequent Visitor
4 years ago

Hi JJ,

I have a similar issue (Can't convert text to date) but my date format is like Q1 13/14, Q2 13/14, Q3 13/14 and Q4 13/14.

The time span starts at Q3 09/10 and ends in Q4 30/31.

Any idea?

Thanks in advance

Q