Forum Discussion
Lisa_2021
Helper II
Helper IIList.Accumulate replacing text with numbers
Hi, is it possible to replace text with numbers? this formula works if I replace text with text but not with numbers? = Table.AddColumn(#"Filtered <> 0", "Metric Index", each List.Accumulate (...
Hi Lisa_2021
You can use Replace.ReplaceValue instead of Text.Replace.For more information please refer:
https://gorilla.bi/power-query/replace-values/
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
