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.
Hello,
Im facing the following problem.
I have two tables related by the function columb.
table 1:
1.1 name 1.2 Function 1.3 Result
Mark A 1
Bella B 3
Chris A 3
table 2:
2.1 Function 2.2 Reference Result
A 2
B 3
C 1
Im am using a filter on 1.1 name to display individual results.
I would like to then use the 1.2 Function of the 1.1 Name to retreive the value in in 2.2 Reference Result.
Thanks for the help!
Solved! Go to Solution.
@addd123
This could be done by creating relationship between those two tables.
Load those two tables into Power BI desktop, then on the left side, click on the relationship tab,
After that, click on the Manage Relationships, then the relationship Windows would appear:
Once created the two tables, Power BI desktop would automatically create the relationship based on the table columns, which we could modify later.
For the detailed information regarding the tab, please check the article below:
Create and manage relationships in Power BI Desktop
The results should be:
If any further questions, please feel free to post back.
Regards,
Charlie Liao
@addd123
This could be done by creating relationship between those two tables.
Load those two tables into Power BI desktop, then on the left side, click on the relationship tab,
After that, click on the Manage Relationships, then the relationship Windows would appear:
Once created the two tables, Power BI desktop would automatically create the relationship based on the table columns, which we could modify later.
For the detailed information regarding the tab, please check the article below:
Create and manage relationships in Power BI Desktop
The results should be:
If any further questions, please feel free to post back.
Regards,
Charlie Liao
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |