List.Accumulate replacing text with numbers

[Lisa_2021]

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 (
List.Numbers (0, Table.RowCount (dim_metric_index)),
[METRIC],
(state, current) =>
Text.Replace (state, dim_metric_index[Metric]{current},
dim_metric_index[Metric Index]{current} )
))

Thank you so much!!

Lisa

[Ritaf1983 · Accepted solution]

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.

[Lisa_2021]

Thank you!!  

[Ritaf1983]

Glad to help 🙂