add a column with the value from another column by index

[Anonymous]

Hello guys!

I have a task that seems simple, but have no idea how to solve this. I have a table with names of services (field "name"), some services are subservices of services inside that same table. I want to add column to that table with the name of parent service by it's "parent id". Could you please tell how i can do it?

Thanks!

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download sample PBIX file

This DAX will create your column

Parent Name = CALCULATE(MAXX('Servises','Servises'[name]), FILTER('Servises', 'Servises'[id] = EARLIER('Servises'[parent_id])))

Regards

Phil

[Anonymous]

Thanks a lot, it did create needed column!