Expression.Error: The name 'LOOKUPVALUE' wasn't recognized. Make sure it's spelled correctly.

Greetings,

New to PowerBI and driving myself crazy trying to get this to work and nothing online has worked thus far. Esssentially I have a table that I need to look up the name value associated to an ID from one column and populate to another. This is my set up:

I'm trying to lookup the Child Substation Name associated to the Network Reference ID and then create a new column Parent Substation Name by looking up the Parent Network Reference ID with the Network Reference ID.

Here's my query that returns the error:

= LOOKUPVALUE(Heirarchy[Child Substation Name],Heirarchy[HeirarchyNetwork Reference ID],Heirarchy[Parent Network Reference ID])

Can anyone help me please?