Parent Project and children Tasks
Hello,
I am trying to create a dashboard in Power BI which contains a project portfolio report and a task overview report. Therefore, I need to differentiate between parents (project) and children (tasks) from my source sheet. I'm doing this by creating a grid that contains just the parent rows and another grid that contains just tasks rows. I'm thinking on this as a relational database.
A project in the source sheet looks like this:
I'm using INDEX formulation, but I'm not sure yet about how to reference parents and children so I can get what I need in each new grid I mentioned before.
Does someone have any suggestion? I'll appreciate it.
Thank you.
Best Answer

Hi @FrankOrtz ,
You might be able to use the parent() function that references your task column and apply it as a column formula:
This will put the parent level task for any children for every row. If the row is a parent level without any ancestors, then the value would be blank, or you can modify the formula to set it equal to itself.
Hope that helps!
Answers

Hi @FrankOrtz ,
You might be able to use the parent() function that references your task column and apply it as a column formula:
This will put the parent level task for any children for every row. If the row is a parent level without any ancestors, then the value would be blank, or you can modify the formula to set it equal to itself.
Hope that helps!

Hello @Chris Mondeau,
Thank you for your suggestion. That's a simple solution which I used as an input to the INDEX() functions. Everything is working as expected.
Thank you again!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!