Date format

Hi can you try these steps? It does seem to work for me:

1) in Power BI click on Edit Queries in the Home Tab

2) Look for the birthdate column, click on it

3) Go to the Transform tab and click on Split Column

4) Choose "By delimiter" and select "Custom" in the dropdown menu that pops up

5) In the textfield below the dropdown, type in "GMT"

6) Pick "left-most delimiter"

7) Press OK

8.) Power BI will split your data in two different columns named Birthdate.1 and Birthdate.2

Birthdate.1 will be transform to a Date/Time type.

9) Don't forget to go to the home tab and press Close&Apply

These steps will result in the following DateTime column

Let me know if this works for you.

Birthdate.1

Hi Anonymous ,

Try the following DAX, I think region is the problem.

Column = 
var a =SEARCH(" ",'Table'[birthDate],1)+1
var b = SEARCH(" ",'Table'[birthDate],5)+1
var c = SEARCH(" ",'Table'[birthDate],9)+1
var d = MID('Table'[birthDate],a,3)
var e = SWITCH(
    TRUE(),
    d="Dec",12,
    d="Nov",11,
    d="Oct",10,
    d="Sep",9,
    d="Aug",8,
    d="Jul",7,
    d="Jun",6,
    d="May",5,
    d="Apr",4,
    d="Mar",3,
    d="Feb",2,
    d="Jan",1
)
return
IF(c=12,
MID('Table'[birthDate],b,2),
0&MID('Table'[birthDate],b,1)
)
&"-"&e&"-"&MID('Table'[birthDate],c,4)

Here is the test file for your reference.