Showing results for 
Search instead for 
Did you mean: 
kimnov Frequent Visitor
Frequent Visitor

question relationships: video creating calculated columns

Dear edX Power BI Team,

I watched the video of Lab 2 called "creating calculated columns" and I have a question concerning the relationships. As in the Sales Table and in the Geography table are zip codes, can there not be made a relationship between those tables depending on the zip code (or the country)?

And If not, why exactly not? What is then the requirement for a relationship?

Thank you very much for your kind help!


Kim J. Novacek

SonaliG_LeX Regular Visitor
Regular Visitor

Re: question relationships: video creating calculated columns


 If you go through the lab instruction : Excercise 1 in lab 2 it is mentioned that the two tables Sales and llLocation donot have any column in common  for the relationship to happen so to create a new column CountryZip  .This is required as you need to extract out the sales datain later excercises based on the location. Thus, there this created relationship will help.

Helpful resources

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 67 members 962 guests
Please welcome our newest community members: