Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Relationships between two columns

Hi!   A newbie to PowerBI, so sorry if the question is really basic, I just don't see the way out of what looks like a very simple problem.   I have some datasets with thousands of data, so I've ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    In addition to Greg_Deckler's method,

    you could also transform the Sales table with Power Query as below:

    go to "Edit Queries", select on "SalesmanId 1" and "SalesmanId 2", select "Unpivot columns",

    Then close &&apply,

    next, create relationship between two tables based on "Sales table"[value] and "salesman names"[SalesmanId]

    Please find more details in my pbix.

     

    Best regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

In addition to Greg_Deckler's method,

you could also transform the Sales table with Power Query as below:

go to "Edit Queries", select on "SalesmanId 1" and "SalesmanId 2", select "Unpivot columns",

Then close &&apply,

next, create relationship between two tables based on "Sales table"[value] and "salesman names"[SalesmanId]

Please find more details in my pbix.

 

Best regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.