Forum Discussion

Frequent Visitor

4 years ago

Solved

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 t...

Need Help

v-kkf-msft
4 years ago
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.
create a new column, using its own table as a reference.pbix27 KB

JonDewar

Frequent Visitor

4 years ago

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,