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.
Greetings,
New to PowerBI and driving myself crazy trying to get this to work and nothing online has worked thus far. Esssentially I have a table that I need to look up the name value associated to an ID from one column and populate to another. This is my set up:
I'm trying to lookup the Child Substation Name associated to the Network Reference ID and then create a new column Parent Substation Name by looking up the Parent Network Reference ID with the Network Reference ID.
Here's my query that returns the error:
= LOOKUPVALUE(Heirarchy[Child Substation Name],Heirarchy[HeirarchyNetwork Reference ID],Heirarchy[Parent Network Reference ID])
Can anyone help me please?
Solved! Go to Solution.
Thanks,
Based on your response I have managed to work it out. The solution is below, essentially I was using power query rather than DAX in PowerBI to create the column I required.
Welcome to the forum.
Remember, write M in Power Query, DAX in PowerBi.
I can help you with the M but you should have a go first
Thanks,
Based on your response I have managed to work it out. The solution is below, essentially I was using power query rather than DAX in PowerBI to create the column I required.
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 |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |