Forum Discussion

lgo's avatar
lgo
Frequent Visitor
6 years ago
Solved

Problem with error handling and dates

Hi everybody!

 

I currently have some dates with the day with "00", let-s say, the sources does not have idea about the day so it is reported as 00. So some of the dates are 00-08-2019. As the column is recognized as a date, those values are reported as a cero. 

 

I find the same situation in other columns, but, it they are not recognized as dates, i have the time to replace -00 for -01 and then change it to date format, and i still keep those values!

 

What can I do for the power query editor to leave the original values for me to able to change them before finding errors? (I have already tried to unclick the option to recognize the data type, but i has not worked so far). 

 

I do not know if i explain mayself in a good way... I hope you guys understand. Thank you in advance!

Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi lgo ,

    you have 2 choices:

     

    1) remove the automatically created changed step manually by clicking the cross

    2) manually edit the automatically created M code and delete only the column whose formatting you want to skip:

     

     

4 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    6 years ago

    Hi lgo ,

    you have 2 choices:

     

    1) remove the automatically created changed step manually by clicking the cross

    2) manually edit the automatically created M code and delete only the column whose formatting you want to skip:

     

     

    • lgo's avatar
      lgo
      Frequent Visitor
      6 years ago

      Thank you so much for your reply! but i can't see the same in my screen!

       

      • lgo's avatar
        lgo
        Frequent Visitor
        6 years ago

        So I have discovered something further....

         

        I have all the tables without Data types in the columns...when I do merge + then expand = some columns got the Data type! Do you know why this is happening?

         

        Thank in advance,

         

        Laura.