Forum Discussion
Helper VTrying to replace errors and replace values dynamically instead of entering static value
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.
Community Championklehar I'm thinking:
#"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type", {"Lease start", Date.AddDays([Funded date],-16)}),
#"Replaced Value" = Table.ReplaceValue(#"Replaced Errors",null,Date.AddDays([Funded date],-16),Replacer.ReplaceValue,{"Lease start"})
in
#"Replaced Value"
First line changed dropping the extra { } items. If this doesn't work, I will try to mock something up.
kleharGreg_Deckler , this doesnt work, can you mock somethign up
- Greg_Deckler
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.
- klehar
Greg_Deckler , Thats how it is already implemented currently. But my transformations already have a lot of steps slowing down the report. I;m trying to reduce every step I can
- Greg_Deckler