Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |