RELATED function for Lookup not working

[ClemFandango]

Hi there,

I am having difficulties with the RELATED formula and hoping someone can help? All I am trying to recreate an Excel style Vlookup table. Am I going about this wrong way?

I have two Queries, TEST1 & LOOKUP. I am trying to add a new column in TEST1 that will return the value from the ‘Area’ column in the LOOKUP query column, where ‘Type (name)’ (from TEST1) matches ‘Type (name)’ (from LOOKUP).

This is the code so far that I am placing inside a Custom Column

[#"Type (name)"] = RELATED(LOOKUP[Area])

I have created a one to many relationship for the Type (name) in TEST1 & LOOKUP

But this is the error message. Does anyone have any idea where I am going wrong?

Any help massively appreciated

[lukiz84 · Accepted solution]

You are trying to use DAX functions in PowerQuery.

[ClemFandango]

Ha! Thank you. You might not beleive this, but this has helped massivley. I never released that DAX was not part of Power Query. Oh dear.