Forum Discussion
How to recode date by M code when user data entry mistake ?
Hi All My CSV file have data entry mistake , the date should 04/01/2017 but user enter wrongly . Can some one share how to recode the date ? My PBI file :- https://www.dropbox.com/...
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
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