Forum Discussion
Solved
Adding A Cell as a Column to an Inner Table
Hello, I'm experiencing some difficulities with the Table.TransformColumns function, specifically, referencing a cell in the row that contains the table I'm modifying. I understand that what I'm ...
The Table.TransformColumns function transforms columns independently. You cannot reference Column B in when defining a transformation on Column A. You can reference multiple columns when defining a new custom column or using Table.ReplaceValue.
I don't really understand what your ultimate goal is here but I don't think you'll likely make things more efficient by doing nested table operations rather than expanding tables.
Simple enough. Table.ReplaceValue() does the trick if you're looking to bring [Dates] column to the calcualtion based on inner tables.