Forum Discussion
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...
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.
v-kkf-msft
Community Support
Community SupportHi 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.