Forum Discussion
klehar
Helper V
Helper VTrying to replace errors and replace values dynamically instead of entering static value
Hi, I have a date called Lease Date. It has some errors and blanks So I had used Replaced Errors and Replcaed Values functions from transformation in power query and replaced such values wit...
klehar Another thought on this. ReplaceErrorValues but use a date like 12/30/2100. Add a conditional column and if that is the value, replace with your AddDays logic, otherwise, just use the existing date. Remove the original column and you are good.
Greg_Deckler
Community Champion
Community Championklehar Well, you need 2 lists for ReplaceErrorValues: Table.ReplaceErrorValues - PowerQuery M | Microsoft Docs
Looks like a similar issue perhaps for ReplaceValues: Table.ReplaceValue - PowerQuery M | Microsoft Docs
kleharHi Greg_Deckler , I'm afraid im not very good at M code. Can you help me explain how this can be done