Reply
Highlighted
Frequent Visitor
Posts: 4
Registered: ‎11-20-2016
Accepted Solution

Lab 1 exercise 2, point 4 :Edit the Sales Query from the US Sales.

Hi all, what should I do in this point (number 4 of ex 2)?


Accepted Solutions
Established Member
Posts: 150
Registered: ‎11-28-2015

Re: Lab 1 exercise 2, point 4 :Edit the Sales Query from the US Sales.

What issue are you having? There have been several long threads about this question. Read through these threads first to see if your issue is listed. If you're hitting a different issue, please provide details and error messages.

 

http://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Lab-1-Exercise-2-Changing-Data-Type...

 

http://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Error-message-Lab-1-part-2/m-p/7008...

 

Thanks,

Sam Lester (MSFT)

View solution in original post


All Replies
Established Member
Posts: 150
Registered: ‎11-28-2015

Re: Lab 1 exercise 2, point 4 :Edit the Sales Query from the US Sales.

What issue are you having? There have been several long threads about this question. Read through these threads first to see if your issue is listed. If you're hitting a different issue, please provide details and error messages.

 

http://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Lab-1-Exercise-2-Changing-Data-Type...

 

http://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Error-message-Lab-1-part-2/m-p/7008...

 

Thanks,

Sam Lester (MSFT)

Occasional Visitor
Posts: 1
Registered: ‎02-15-2017

Re: Lab 1 exercise 2, point 4 :Edit the Sales Query from the US Sales.

I don't quite understand this step. I reas through those 2 suggested links but didn't find specifics on how to go from here. The Sales query has no Country column. Is this step asking me to edit the query to refer to the Locations query, which contains the Country and Zip code ?
Frequent Visitor
Posts: 3
Registered: ‎11-21-2017

Re: Lab 1 exercise 2, point 4 :Edit the Sales Query from the US Sales.

The whole query named as Sales is related to the USA Sales.

Frequent Visitor
Posts: 3
Registered: ‎11-21-2017

Re: Lab 1 exercise 2, point 4 :Edit the Sales Query from the US Sales.

The whole query named as Sales is related to the USA Sales.

Frequent Visitor
Posts: 2
Registered: ‎07-23-2018

Re: Lab 1 exercise 2, point 4 :Edit the Sales Query from the US Sales.

Hey Sam,

I have the same question like Whre can I find the US Sales query? in Sales is no US, in the Location query under "Country" I can fine the USA, but I have no idea what to do know????

 

thanks   

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

Re: Lab 1 exercise 2, point 4 :Edit the Sales Query from the US Sales.

hi, have the same problem because i cannot understand what the want us to do in this question, the task is not specific as to which table to use. The question is very vague to me, it microsoft can help review the Question is being asked then i'll be very happy cuz i'm stuck here