Forum Discussion
problem with date format
Hello, I am working with dates that are stored as text. I changed the type to date/time but not all the cell are translated to date/time. I have error in the power bi transform data with t...
This should work Anonymous in a new custom column in Power Query
try DateTime.FromText([Column1]) otherwise DateTime.From(Number.From([Column1]))Then just rename it Date, and change the format to DateTime or Date if you don't care about the time. Make sure the first column is in text. You have data coming in in different formats so Power Query cannot do one single change to all of it to work as you'd like.
This should work Anonymous in a new custom column in Power Query
try DateTime.FromText([Column1]) otherwise DateTime.From(Number.From([Column1]))
Then just rename it Date, and change the format to DateTime or Date if you don't care about the time. Make sure the first column is in text. You have data coming in in different formats so Power Query cannot do one single change to all of it to work as you'd like.
it works
thanks a lot
Great Anonymous - glad I was able to assist.