Forum Discussion
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 (
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
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.
3 Replies
- Ritaf1983
Super User
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.
