Forum Discussion

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous -You can replace it with the correct date in Power Query.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Sir

      Can you pls share with me how to write M code , if INV = 110102 and date = 04 January 2030 , Replace by 04 January 2017 . 
      Paul

      • mahoneypat's avatar
        mahoneypat
        Microsoft Employee
        5 years ago

        Just highlight the Date column in the query editor and click on Replace Values in the ribbon, put 1/4/2030 in first cell and 1/4/2017 in second (assuming you have no rows where 1/4/2030 would be the correct value).

         

        Regards,

        Pat

         

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi Anonymous , please refer to the image below.

    Best regards,

    Jing

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Jing

      That is good suggestion. in case one of the invoice sales staff enter the wrong date , and this date we have 20 invoice , how to change the date link to invoice numner ?

      Paul 

      • v-jingzhang's avatar
        v-jingzhang
        Community Support
        5 years ago

        Anonymous With this replace values function, it will replace all the same wrong date in the selected date column with the correct one no matter what invoices they are linked to. 

        Jing