Forum Discussion
gittelena
10 years agoMicrosoft Employee
Question about adding a new column and adding formulas
I am in the process of doing an intro Power BI course. In the training materials it says: "In the Sales query, add a custom column named Country Name which takes the value of the Country colu...
nwzomer
10 years agoNew Member
I am also trying to work on the same instruction of the course. What you provided did not work, PowerBI gives a "Token Eof Expected" error and won't allow me to use the formula. These were the full instructions, perhaps this will help give more context. Stuck on #6.
- Download the zip file containing VanArsdel's international sales data and extract it to a folder. You should see 4 CSV files in the folder.
- Import the data from the file folder by using the Get Data. To do this, click the Get Data / More option, selectFolder and click Connect. Select the folder where you saved the 4 CSV files containing VanArsdel’s international sales data.
- Perform the following steps:
- Name the query International Sales.
- Select to combine (combined binaries) the content of those 4 files.
- Filter the rows that come from the header of the CSV files. (Hint: One way to do this is to filter out the Country column from records containing “Country”).
- Filter the rows that are after December 31st, 1999.
- Edit the Sales Query from the US Sales.
- Append the International Sales Query to the Sales query from the US Sales.
- In the Sales query, add a custom column named Country Name which takes the value of the Countrycolumn when it is not null and the value of "USA" when the Country column is null.
- Remove the Country column.
- Load the data into Power BI Desktop. This might take a few minutes.
- Explore the imported data in the Data View.
- Hide the International Sales table from report view.