Forum Discussion
Pivot with multiple values scatered thorugh rows + nulls (Powerquery)
ngboss707 it will be easier if you unpivot this:
Transform data -> select IP -> right click -> Unpivot other columns
it will create two column, attribute and value, rename as you see fit, close and apply
Use matrix visual, put IP on rows, attribute on column and value on values and that will do it.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
ngboss707 can you share the pbix file, remove sensitive information before sharing.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
Hi parry, I think I got it by looking on how to use custom measures from other forum posts here. Just a question: is it possible to make a row for each distinct value in each column, with the IP column and other columns merged if there is only a single value in that column? I know I said before that it doesn't matter how the final result is presented, but I found it hard to filter the values in others columns because of the concatenations, something like this: