Forum Discussion
Transform By Dividing Based On Another Column Conditionally
Correct. Table.TransformColumns only transforms columns individually. You can't cross-reference other columns in the transformation definition.
The easiest method is usually to define a new custom column instead of transforming an existing one since you can reference multiple columns that way.
the function of Table.TransformColumns can not get the value of other columns, you can try Table.ReplaceValue
= Table.RepaceValue(#"Grouped Rows2",each [AD Account],"",(x,y,z)=x/(1+Byte.From(y="hams, Magdoulin)),{"Tenure"})
So, this is something I cannot tweak the below to get output?
= Table.TransformColumns(#"Grouped Rows2", {{"Tenure", each _ / [Count], type number}})
Correct. Table.TransformColumns only transforms columns individually. You can't cross-reference other columns in the transformation definition.
The easiest method is usually to define a new custom column instead of transforming an existing one since you can reference multiple columns that way.