AR Table Date field import as Text unable to convert to date

[Paulyeo11]

Hi All

My AR Table date field imported to PBI as Text.

I try to convert it to Date. 

When i click on replace current  , all the date erase off. 

My PBI File :-

https://www.dropbox.com/s/dw3ay2or8db3100/AR_ISDN%20v003.pbix?dl=0

I have already import few raw data to PBI before no issue.

Paul Yeo

[PhilipTreacy · Accepted solution]

Hi @Paulyeo11 

Those dates are in m/d/y format.  You need to click on the column header and then Change Type -> Using Locale and choose Date, English (United States).

Regards

Phil

[Paulyeo11]

Hi Phil

Thank you very much for your help it work fine now.

Paul Yeo

[amitchandak]

@Paulyeo11 , my system has the US date format. SO I was able to change data type to date . You can try that in a power query or data view.

in case you have a UK format. Then better to have a new column like

new date =
var _pos = search("/",[col],,0)
return
date(right([date],4), mid([date],_pos+1,2), left([date],_pos-1))

and use that

[Paulyeo11]

Hi Amit

Thank you for your help. 

I try at PQ , i get error :-

I try PBI , i also get error

Hope you can advise me

Paul