Forum Discussion

moabaza's avatar
moabaza
Frequent Visitor
3 years ago

Relationships

Hello,

I have two data sets each one them have two columns (Type, Name), and i want add a filter for both datasets but i could not to build relationships between both columns, how can i do it?

I want to have a relationship between colum "Type" in dataset 1 and column "Type" in datset 2, and to have another relationship between column "Name" in dataset 1 and column "Name" in data set 2. 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

     

    You cannot separately introduce two different columns as relation between two tables, you have to combine them to create a key column.

    For example

    KeyColumn = Concatenate('Table'[Type],'Table'[Name])
     

    Best regards,

    Ezgi Naz Aslankara

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly