How to show relationships

[mwnance]

I have 1 table which has an ID and a title.

then I have another table that has the id and another ID that ID has relation ships with.  the ID can have 1 1 or more relationships.

I would like to either create a table with the relatied Ids or even better a chart that shows the relation ships.  OR even better plot them on a timeline with the link shown.

If anyone can help with any part of this I would greatly appreciate. 

I have linked the ID to the ID n the relationship table but the related ID and getting its title from the first table is where I am having probllems.

[v-xiaotang]

Hi @mwnance 

Thanks for reaching out to us.

Usually I would use filter(), e.g. calculate(max(tableA[name]),filter(tableA,tableA[ID]=max(tableB[ID]))

Best Regards,

Community Support Team _Tang

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

[srlabhe123]

Can you please share your data , didnt get your requirement here?