Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
You are trying to use DAX functions in PowerQuery.
You are trying to use DAX functions in PowerQuery.
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |