Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Custom Replacer.ReplaceText

I have no idea why this is not working.  I am trying to add a custom holiday to my date table. I get no error code. It acts like it has repaced the value but the cell is empty rather than XXXXXXX. W...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago
    #"Replaced Value" = Table.ReplaceValue(#"Sorted Rows", each [Holiday], each if [Date] = #date(2021, 4, 2) then "XXXXXXXXXX" else [Holiday], Replacer.ReplaceValue,{"Holiday"})
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I am not sure why this worked because it appears to be the exact same thing as I was doing but it works.  Thank You Very Much