Please refer the pic, I have to do that same thing but using dataflow

CodePudding user response：

Create Derived column activity this activity helps you to create a new column trough data flow, give column name what you want and in expression give.

(col1 col2 col3)/3

OUTPUT