Forum Discussion
Solved
Expression.Error: We cannot apply field access to the type Number.
I am trying to randomize data in-place: #"Randomize" = Table.TransformColumns(#"Changed Type1", {{"Value", each Number.RandomBetween(0.95,1.05)*[Value]}}) However, I get the following error m...
try this
#"Randomize" = Table.TransformColumns(#"Changed Type1", {{"Value", each Number.RandomBetween(0.95,1.05)*_}})
PS
if the answer works for you and you want to know how and why it works, just ask
try this
#"Randomize" = Table.TransformColumns(#"Changed Type1", {{"Value", each Number.RandomBetween(0.95,1.05)*_}})
PS
if the answer works for you and you want to know how and why it works, just ask