Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Self relationship for a Table

Hello all, 

I have a question. Is it possible to create a self relation in power bi? I have a table and the values in this tables can be used both parent and child. That's why I have thought that I can create a self relation and use the same columns with different goals. If it's not possible, do you have any suggestion about this case? 

Thanks

Need Help
Show and Tell

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , You have brought one more copy with a different name, or create a copy in power query of DAX

     

    Dax example 

    New Table = 'Old Table'

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    Can you provide example data and desired output/functionality?  FYI that, if needed, you could pass filters between two columns in the same table with TREATAS.

    Pat

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous 

    Not very clear if there is better solution in your case, you may create a copy of the table to have a parent table and a child table with relationship.

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.