39
When adding Columns in Power Query there is no option to choose the data type, so columns are added as untyped.

Users are left to add another step, or manually edit the function to set the optional columnType parameter.

In all of the Add Column windows (Custom Column, Conditional Column, Column from Examples) I would like to see a drop-down where a type can be chosen to populate that columnType.
STATUS DETAILS
Needs Votes

Comments

B

Also: When changing the type on a column immediately after the step that created it, offer a similar message to the one that already exists on successive type conversions:


"The selected column allows type to be specified when created. Would you like to replace the existing conversion, or preserve the existing conversion and add the new conversion as a separate step?"

B

Very useful! Writing a type into the Table.AddColumn function is a great way to keep code clean and intuitively understandable, versus adding a Change Type step. Ability to select this directly in the Custom Column and Conditional Column interface would be very helpful!

B

Wow! It will be so really great solution! I support this idea.

B

This would be very useful. It saves a step and prevents mistakes (columns with data type any)