Forum Discussion
Helper IIHow do I lookup values and replace from another table that has delimited values?
Hello All,
I'm trying to understand how to lookup values from another table. I keep getting directed to things that don't work so I'm confused.
I keep getting articles on DAX but I'm not sure DAX is the right thing. Or if Powerquery does it. Or WHAT I should be doing... 🙂
I have a list of values: This is from PowerQuery.
The numbers correspond to a list of values in another table. In that other table there records associated with it and I want to pull the names.
I'm not sure if I should be in PowerQuery and do something there. Or if I should be in the main console and using DAX.
I see mention of using VLOOKUP which I think is DAX. I'm just a little lost at the moment on my next step.
I'm not even sure of what my options are in PowerQuery yet. I'd think it would be faster there.
6 Replies
- parry2k
Super User
ComputerHabit The correct way to do this is to split the job id into rows by delimiter and then each row will have a single job id. Once this change is done, you can either merge with the job table in PQ or just set a relationship in the model between two tables and should be able to pull the relevant information from the job table.
Keep in mind, that the best practice is to get the detailed data by row, and in your case that is not the case. There will be other solutions but will refrain as they will complicate things for no reason and can have performance issues on large datasets.
- ComputerHabit
I'm not sure I really follow what you mean by split into rows.
The column itself is a bunch rows. I'm wanting to replace the numbers with the text values from a lookup.
- parry2k
Split the job id column to the row, each column of job id contains by job ids and you need to break it down to rows.
- ComputerHabit
You are making no sense.
It's like you're asking me to go back and rearrange a database. That isn't happening.
The values are like 1;2;3;4. In one cell there can be 300 items. Splitting those out into additonal rows would be like adding 20000 additional rows.
You also provide no context to HOW and that's why I need help.
And what you're saying isn't making sense because it's short and not useful.
- parry2k
Your reply also doesn't make sense because you don't know the basics of how power bi work. good luck
- ComputerHabit
You're right. Hence the forums. You are sooo smart. 🙂
