Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    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. 

     

     

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , if data is coming from excel. Correct the format there and try. Seems not all in same format at sources.

 

What is data source ?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I don't want to make changes via ecel , only via power bi so it will be automatic when I will get more

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    edhans , ImkeF , Can you suggest come code for this. Values are in excel date format - both number(date as number) and date