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

v-jiascu-msft

 

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!

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Please refer to the snapshot and the comments on the code.

Table =
FILTER (  //filter out blanks, for you want to establish relationship.
    DISTINCT (  //only keep unique values.
        SELECTCOLUMNS ( 'DimProduct', "key", CONCATENATE ( [BrandName], [ColorName] ) )
    ),  //concatenate two fileds as you mentioned. 'DimProduct' is a table while [BrandName] and [ColorName] are columns of 'DimPorduct'.
    ISBLANK ( [key] ) = FALSE ()
)

Reference_Table_through_Power_BI_PLEASE_HELP

 

 

Best Regards,

Dale