Forum Discussion
How to create a new column, using its own table as a reference
Hi JonDewar ,
Please try the column.
Column = CALCULATE( MAX('Table'[Title]), FILTER('Table', 'Table'[ID] = EARLIER('Table'[Parent ID])))Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi JonDewar
What is the Parent title, share example
If Parent Title need to generate from another table, please use LOOKUPVALUE
https://www.youtube.com/watch?v=vW2B84PdKyQ
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
Sorry if my first post was not explicit enough.
Exmaple Data Set:
| ID | Title | Type | Parent ID | Parent Title *New |
| 1 | Word | User Story | 3 | Microsoft Office |
| 2 | Excel | User Story | 3 | Microsoft Office |
| 3 | Microsoft Office | Feature | 4 | Bill Gates |
| 4 | Bill Gates | Epic |
If you notice above, all of the information needed is in the same table, I just want the Parent Title Column, to look up the Parent ID field and bring back the title for that ID.
Does that help?
Thanks,
JD
What is the logic for Parent Title
if word, then Microsoft Office
like that