Forum Discussion

Regular Visitor

8 years ago

Solved

Relating tables with repeated fields

Dear all, Till now I worked with Qlik Sense and enjoyed the QLIK engine, by which related columns are automatically related. I'm new to BI and what I found out till now is that BI does it another...

iamprajot
8 years ago
I don't get it, what the Problem is but here is something that might help with the Relationships.

Go to Modeling Tab and Create new Table based on Distinct Values so that there are no Repeated Values
Table = DISTINCT(TableName[ColumnName])

Then Create Relationship of other Tables with this one,

Go to Home Tab and Manage Relationships to Edit or Create Relationships
Select Table Name and Manager Column Name in both Tables

Also, Cross Filter Direction should be Both

Responsive Resident

8 years ago

I don't get it, what the Problem is but here is something that might help with the Relationships.

Go to Modeling Tab and Create new Table based on Distinct Values so that there are no Repeated Values

Table = DISTINCT(TableName[ColumnName])

Then Create Relationship of other Tables with this one,

Go to Home Tab and Manage Relationships to Edit or Create Relationships

Select Table Name and Manager Column Name in both Tables

Also, Cross Filter Direction should be Both

Regular Visitor

8 years ago

Thanks for your reply, I will test it out. For better understanding, this is what my unrelated tables look like before:

So what has to be related is the customer ID.

When I let Excel power query relate it, the result looks like this:

I am not sure whether I could use such data in a senseful way in Power BI, because I'm used to other BI software.