Forum Discussion
Transform By Dividing Based On Another Column Conditionally
Hello there, Can someone help me on spotting the problem with this script: = Table.TransformColumns(#"Grouped Rows2", {{"Tenure", each if [AD Account]="Shams, Magdoulin" then _ / 2 else _, ty...
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.
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.