Self relationship for a Table

[Anonymous]

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

[V-pazhen-msft]

@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.

[mahoneypat]

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

[amitchandak]

@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'