Skip to main content
Microsoft Idea

Power BI

Needs Votes

Option to define datatype when creating column in Power Query

Vote (1) Share
James Ward's profile image

James Ward on 07 May 2020 20:48:29

Allow users to pick their data type when creating columns via the UI. Currently when you add a column via the UI (for example, the conditional column button) it defines the data type as any. To change this you either have to add another step or if you are comfortable and knowledgeable about M you can edit the create column step in the advanced editor (though if you are comfortable with M you are probably writing the step in the editor and not the UI). By having the option to pick the data type in the UI you can help end users reduce "step clutter."