How to create a Dashboard with Predecessors and successors jobs list

[Syndicate_Admin]

Hi all,

I have some data in my SharePoint online list as below

From the above data, I need to create the below output in the form of Parent child relationship

Full Job Stream

PHH657VP --> PHH657J9 --> PHH657JI --> PHH657JC, PHH657JD, PHH657JE, PHH657HF, PHH657JG, PHH657JH --> PHH657JB

PHH657JU --> PHH657JI --> PHH657JC, PHH657JD, PHH657JE, PHH657HF, PHH657JG, PHH657JH --> PHH657JB

OR

Full Job stream

PHH657JB --> PHH657JC, PHH657JD, PHH657JE, PHH657HF, PHH657JG, PHH657JH --> PHH657JI --> PHH657J9 --> PHH657VP

PHH657JB --> PHH657JC, PHH657JD, PHH657JE, PHH657HF, PHH657JG, PHH657JH --> PHH657JI --> PHH657JU

I have tried with PATH function and MAXX function but it was not working. Any help to get this achieved is much appreciated

Thanks in advance!

[Syndicate_Admin]

Thanks for your response, Can you please provide me the formula that you have used for output purpose ?
I am not able to see it from the snapshot that you have provided

[lbendlin]

Output =
CONCATENATEX (
    ADDCOLUMNS (
        GENERATESERIES ( 1, PATHLENGTH ( [p] ) ),
        "pv", PATHITEM ( [P], [Value] )
    ),
    [pv],
    "-->"
)

[lbendlin]

PATH should work for this.  

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Syndicate_Admin]

Hi there, please find the attached input and out data in excel format and provide me an input to proceed further with my business problem.

It has both input and output sheets created for easy reference.

[lbendlin]

Your sample data is a bit inconclusive but here is the general approach: