RELATED function for Lookup not working

ClemFandango — Tue, 29 Nov 2022 13:31:32 GMT

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

Re: RELATED function for Lookup not working

lukiz84 — Tue, 29 Nov 2022 14:17:13 GMT

You are trying to use DAX functions in PowerQuery.

Re: RELATED function for Lookup not working

ClemFandango — Tue, 29 Nov 2022 15:03:30 GMT

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.

topic Re: RELATED function for Lookup not working in DAX Commands and Tips

RELATED function for Lookup not working

Re: RELATED function for Lookup not working

Re: RELATED function for Lookup not working