Creating ParentProjectID from ProjectID

Power Query Data Setup
1

Hello All,
I want to create a ParentProjectID from the Project ID for these sample records to develop a parent-child hierarchy and flatten the table using the PATH DAX function. Anyone’s help will be appreciated.
Thanks.
Project.xlsx (10.2 KB)

2

HI @Godzy

Part the forum rules is that we don’t directly address someone or some people within the forum for their help. It discourages others in helping you.

thanks
Keith

1 Like