March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
25 | |
18 | |
15 | |
9 | |
8 |
User | Count |
---|---|
37 | |
32 | |
18 | |
16 | |
13 |