Reply
Frequent Visitor
Posts: 2
Registered: ‎11-25-2016
Accepted Solution

Exercise 2: Import Data from a Folder Containing CSV Files HELP

Hi. I have some problems in this excercise i hope some one coudld help me.

 

I download the zip file with 4 files in CVS the file names are:

 

1.png

 

I have import the files into the power bi, rename the query and also combine this 4 files

 

2.png

 

When i combine this 4 files y get 4 steps aplied.

 

3.png

 

4.png

 

I use the last step to remove the headers of the colum Country and the i filter the date after 31/12/1999 (here i chenge the data into dates)

 

5.png

 

6.png

 

I got problems from here the point 4

 

Edit the Sales Query from the US Sales.

 

I dont find anywhere the USA sales. i have from the last excercise the sales query

 

7.png

 

But in this query i dont find any where the USA sales, USA country or NULL cells.

 

8.png

 

9.png

 

A did anything wrong in any step or i miss some step.

Please HELP

Thanks

Rodrigo.

Note***

I have change my settings in regional configuration into English United States in the Editor and Power Bi Deskpot

 


Accepted Solutions
Super User
Posts: 939
Registered: ‎06-09-2016

Re: Exercise 2: Import Data from a Folder Containing CSV Files HELP

As you follow along, You have to append International Sales table to the Sales Table in your  query.

 

This will create null values in the country column which can be converted to the USA by either creating Custom column or conditional column.

 

Hope this helps.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post


All Replies
Super User
Posts: 939
Registered: ‎06-09-2016

Re: Exercise 2: Import Data from a Folder Containing CSV Files HELP

As you follow along, You have to append International Sales table to the Sales Table in your  query.

 

This will create null values in the country column which can be converted to the USA by either creating Custom column or conditional column.

 

Hope this helps.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Frequent Visitor
Posts: 2
Registered: ‎11-25-2016

Re: Exercise 2: Import Data from a Folder Containing CSV Files HELP

Thanks for your time, you help to solve the Exercise.

 

Thanks

 

Jorge Rodrigo

Frequent Visitor
Posts: 2
Registered: ‎06-27-2018

Re: Exercise 2: Import Data from a Folder Containing CSV Files HELP

Thanks. You helped Me a great Deal

Highlighted
Frequent Visitor
Posts: 3
Registered: ‎01-23-2019

Re: Exercise 2: Import Data from a Folder Containing CSV Files HELP

I am unable to import them. It just says Zip file.