Forum Discussion

addd123's avatar
addd123
Frequent Visitor
10 years ago
Solved

Retreive values based on relation in different tables

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...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    10 years ago

    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

v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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