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

Oh OK!  In that case:

 

 

#"Sorted Rows" = Table.Sort(#"Added Custom4",{{"Custom", Order.Descending}}),

#"Replaced Value" = Table.TransformColumn(#"Added Custom4", {{"Holiday", each if [Date] = #date(2021,4,2) then "XXXXXXXXXX" else [Holiday]}})

 

--Nate