Dimensional Table relationship with 2 columns

[joshua1990]

Hi all!

I have a multi level parent-child hierarchy in a table like this:

Parent	Child	Level
A	A1	1
A1	KL2	2
A1	PL0	2

Then I have a dimensional table that contains information for each parent and child.

Now I would like to create a matrix visual that shows this:

Item

Attribute 1

Attribute 2

How would you build the data model to accomplish this?

[Anonymous]

Hi @joshua1990 ,

If you want to create hierarchy in matrix or data model, I suggest you to try PATHITEM.

If this still couldn't help you solve your issue, please show me more details about your issue. And you can show me a screenshot with the result you want.

Best Regards,
Rico Zhou

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