Forum Discussion
Solved
Network diagram problem
I have a table of reference numbers, which I have organised into a hierarchical structure using index and parent. (I’ve also used PATH function to create a column with the hierarchical path) ...
Hi, SparksWillFly
You need to add a new calculated column 'Parent RefNo'.
Parent RefNo = CALCULATE(MAX('Table'[RefNo]),FILTER(ALL('Table'),'Table'[Index]=EARLIER('Table'[Parent])))Then apply it to Network diagram.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Eason, thank you so much! Thats perfect 😄
We beginning to think it was impossible.
I owe you one.
Kind regards
Mark