Forum Discussion

Orstenpowers's avatar
Orstenpowers
Icon for Post Patron rankPost Patron
6 years ago
Solved

Text date into real date???

Good Morning everybody,   The below, highlighted date column is formatted as text. When trying to change the format into date, I got the error message that this cannot be done automatically!? What...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Orstenpowers ,

     

    Here we go:

    year = var year = RIGHT('Table'[Order Date],4)
var month =MID('Table'[Order Date],4,2)
var day =LEFT('Table'[Order Date],2)
return
date(year,month,day)

    Pbix as attached.

     

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi Orstenpowers ,

 

i would also prefer the power query away from Ashish_Mathur .

If there are value errors in the column, they can be easily identified.