Forum Discussion
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...
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
What is the first step in creating a new table. It is no longer in the "Modeling" tab?
Can you also breakdown the components in the DAX starement so I understand the references and how to translate that to my dataset and how they apply?
Thanks!
On the "Home" tab "Enter Data"