Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
In one of Udemy's example exams, there is a question about two tables - SALES and CITY DATA. They look as following:
City data
State (citydata) | city | Population (million) |
Sales
State (sales) | Type | Sales |
State in both tables contain similar values.
In the question you have to say whether a statement is correct or not. The following statement is, according to them, incorrect. However, I don't understand why, as the function RELATED is working on the one-side of relationships, that can import a column into the sales table:
Can anyone explain?
Solved! Go to Solution.
Looking at the tables:
Sales is at the state granularity.
The city table is at the city granularity so each state there has multiple cities. Eg it might look like:
State | City |
A | 1 |
A | 2 |
A | 3 |
B | 4 |
B | 5 |
B | 6 |
C | 7 |
C | 8 |
(Note City is unique but State is repeated).
You can join state to state between the tables but it will be many to many not 1 to many.
RELATED as you're aware only gets data from the 1 side of a 1 to many relationship.
Looking at the tables:
Sales is at the state granularity.
The city table is at the city granularity so each state there has multiple cities. Eg it might look like:
State | City |
A | 1 |
A | 2 |
A | 3 |
B | 4 |
B | 5 |
B | 6 |
C | 7 |
C | 8 |
(Note City is unique but State is repeated).
You can join state to state between the tables but it will be many to many not 1 to many.
RELATED as you're aware only gets data from the 1 side of a 1 to many relationship.
Thanks! I understand it now.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |