Reply
New Member
Posts: 1
Registered: ‎08-22-2016

Lab 1 q4

I am struggling with Lab 1 Qu4 in regards to the csv file import....and the steps follolwing:

4. Edit the Sales Query from the US Sales.

5. Append the International Sales Query to the Sales query from the US Sales.

6. In the Sales query, add a custom column named Country Name which takes the value of the Country column when it is not null and the value of "USA" when the Country column is null.

 

Any help is greatly appreciated.

Frequent Visitor
Posts: 12
Registered: ‎08-11-2016

Re: Lab 1 q4

What's the problem that you're seeing?  Are you looking for assistance on how to perform some steps, or are you getting an error message?

Frequent Visitor
Posts: 2
Registered: ‎01-31-2017

Re: Lab 1 q4

[ Edited ]

6. In the Sales query, add a custom column named Country Name which takes the value of the Country column when it is not null and the value of "USA" when the Country column is null.

Which formula can i use to solve that problem

Highlighted
Member
Posts: 106
Registered: ‎03-10-2016

Re: Lab 1 q4

You can refer to video "1. Power BI Desktop Data Transformations > Transforming Data using Power BI Desktop > Connecting to Files in a Folder" from 4:08