Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Ask the Fabric Databases & App Development teams anything! Live on Reddit on August 26th. Learn more.

M Code suggestion: Table.ExpandTableColumn - Add data types OR keep data Types from previous step.

In Power Query, the current Table.ExpandTableColumn function does not allow users to submit the datatype for the columns like so many other functions allow. It forces us to create an additional step to then identify the columns data type. It would be even better if it kept the same data types from previous steps (Specifically the group by function as a previous step). However, if that is not possible, it would be great if we could update it from...


Current Algorithm:

= Table.ExpandTableColumn(#"Grouped Rows by Name", "Index", {"Original Position","Position","Department", "Status", "Index"}, {"Original Position","Position", "Department", "Status", "Index"})


Future Algorithm:

= Table.ExpandTableColumn(#"Grouped Rows by Name", "Index", {"Original Position","Position","Department", "Status", "Index"}, {{"Original Position", type text},{"Position", type text},{ "Department", type text}, {"Status", type text}, {"Index", Int64.type}})

Status: New
Comments
fbcideas_migusr
New Member
Status changed to: New