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

[Anonymous]

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?

[HotChilli]

Welcome to the forum.

Remember, write M in Power Query, DAX in PowerBi.

I can help you with the M but you should have a go first

[Anonymous · Accepted solution]

Thanks, 

Based on your response I have managed to work it out. The solution is below, essentially I was using power query rather than DAX in PowerBI to create the column I required.