Forum Discussion
How to create a new column, using its own table as a reference
I am pulling data out of azure dev ops, board views. If your familiar with agile and ADO's analytical views, it gives you one table filled with all of your epics/features/stories/tasks. Included in this dump is the:
- Work Item ID
- TItle
- Work item type (epic/story/etc.)
- Parent ID
- Myriad of other fields.
I want to create a new column referencing its own table, to pull the parents title, since all of the information is already there. Here is a picture of what I am trying to do:
I feel like it should be simple, I could easily create a join to a new table, but im fairly new to PowerBI, I do not know how to "use its own table as a reference" if that makes sense?
Thanks for the guidance! JD
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.
4 Replies
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/KudosSorry 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
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.
