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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous

 

Thanks, one last question.  To create the relationships, I am concatenating two colums.  Since this is a function, I can't seem to remove the duplicates in Power Query.  Any thoughts?

 

Thanks!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

You will still get that option. Right click on the customn column you have created , you will see Remove duplicates option.

 

Thanks
Raj

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Anonymous wrote:

    You will still get that option. Right click on the customn column you have created , you will see Remove duplicates option.

     

    Thanks
    Raj

     

     

    Did you try this?

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous

     

    There doesn't seem to be the option to remove duplicates as the column I created using the CONCATENATE function is not showing in Query Editor?