Forum Discussion

eric142's avatar
eric142
Frequent Visitor
4 years ago

Need help in trying to create a relationship

I am new to Power BI and am having a hard time trying to figure out how to do a relationship to one of my tables.   This is a small sample of my spreadsheet that I am using, what I am trying ...
Need Help
speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

Hi eric142

 

In Power BI edit your blue table using the Power Query editor wizard

 

Select the the catagory columns:

  • verify serial number
  • Front kick plare
  • modern velrco
  • and Ethernet columns 

     Click Transform and Unpivot Columns

     

    Congrats, you now have a normal tables that you can join and do looks up on.

     

    Please click thumbs up and accept as as solution buttons, Thanks 

     

     

eric142's avatar
eric142
Frequent Visitor
4 years ago

speedramps 

Thank you for that information I played with and still can't seem to get what I need.

I had to change my spread sheet and was able to get it to work thank you.