Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Reference Table through Power BI - PLEASE HELP!

I am trying to build a relationship between two tables.  One of the tables was supposed to have unique values, to create a relationship.   Is there a way in PowerBI to take a column from a table, c...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous

     

    You can easily do this in Power Query.

     

    Right click Original Table, select Reference , Remove the unwanted columns, select "Remove Duplicates", now you will have the column with unique values .

     

    You can use this table as Relationship / Bridge table as you needed.

     

    Thanks

    Raj

cb_ohio's avatar
cb_ohio
Frequent Visitor
7 years ago

One quick and easy method would be to make a reference copy of one of the tables and group by the column you want distinct values for.  You can eliminate any of the other columns you don't want.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    cb_ohio

     

    Can you send me some screenshots or steps...not sure I know how to do this.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yes, you can do that way also, Both gives same result.

       

      Click on the column you created, Go to Transform Tab -> Click Group by , it will create 2 columns , one is the unique value of your column and another one is based on your selection ( ex: count). You can delete the extra column and keep the custom column.

       

      Thanks
      Raj