Power BI Get Parent Name using dax-CodePudding

Hi I am new to Power BI. I want to get parent name which based on parent code as table mention here. I have manage to do that using duplicate table in model and perform join. But I need to do that using dax expression as new column. Appreciate your help here.

as table above I want to get parent name based on parent code. eg.100 = A

Thank you

CodePudding user response：

Use this expression in a calculated column

Parent Name = 
LOOKUPVALUE(
    'Table'[Name],'Table'[Code],
    'Table'[ParentCode])

Please help improving StackOverflow:
Accept this answer, if it solved your question. If not, comment why!