Defining column data types properly early on in your data scrubbing process can help to determine the type of values you are working with. The Power Query Editor has various numeric, text, and date-time data types for you to choose from. In our current example, all of the data types were automatically interpreted correctly by the Power Query Editor, but let's look at where you could change this if necessary:
- Locate the data type indicator on the column header to the right of the column name
- Click the data type icon, and a menu will open that allows you to choose the new data type you desire:
Choosing the Data type
Another method ...
