Last answered:

23 Jul 2023

Posted on:

03 Feb 2023

0

I'm pretty sure the course didn't teach how to pull a column from another table, only merge

I managed a way, but how should I be doing this?

4 answers ( 0 marked as helpful)
Instructor
Posted on:

04 Feb 2023

0

sorry, I am not sure I understand your question. Inside this lesson there is no need to pull columns from other tables. At the end of the lesson we are doing a demo by selecting several columns into a table visual

Posted on:

04 Feb 2023

0

Hi Dimitar, my question is about the assignment steps.

The step 6 says "On the Orders table you need to add a column that represents the currency for each country, the only column that you need is “ISO Code” from “Currency Country” (which function are you going to use?)."

How should I add a column with currencies code in Orders table if I don't pull from another?

Instructor
Posted on:

04 Feb 2023

0

Please re-watch the video about merging queries from Power Query.

Posted on:

23 Jul 2023

0

You can get the column from other table using the Merge Queries. 

Submit an answer