Forum Discussion
How 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 ...
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.
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.
