when try to change the date field from date to text i get error msg

[Paulyeo11]

Hi All

After import sales order CSV file to PBI , for date field , it is import as text .

when i try to change the date field from text to date , i get error msg

[amitchandak · Accepted solution]

@Paulyeo11 , DD/MM/YYYY format. You have to choose the system setting

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...

or create new date

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

[Paulyeo11]

Hi Amit

So for all my raw data date , i should info my IT staff to change to MM/DD/YYY right ?