Question:
From the Power Query Editor, you import data from a .csv file. The data includes a column named ZIP that contains postal codes from the United States.You notice that Power Query Editor automatically applies the Whole Number data type to the ZIP column.You need to ensure that the ZIP column uses the Text data type and that all values remain 5 characters long.What should you do? From the data view in Power BI Desktop, change the column data type from number to text. From Power Query Editor, add a new applied step at the end of the query to convert the ZIP column from number back to text. From Power Query Editor, delete the changed type step. From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column.
Author: da-biAnswer:
From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column.This answer is correct.
0 / 5 Â (0 ratings)
1 answer(s) in total