Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear Experts,
In the last couple of week, I've been working on an excel table and I would like to know if there is a possibility to move an especific cell to another position (sort of like an unpivot)
I get the data as it looks like in the yellow color image, and I'm trying to unpivot the data with power query but I would also like to try to move the cell from the green color position to the red one (next image)
Is this possible with power query?
How I get the data
I am capable of transforming the table to a estructure database, however I would like to get that red color cell in another column.
I am attaching you the PBIX in which i've been working on. (the example file is attached)
Solved! Go to Solution.
is this what you are after?
Dear @Anonymous ,
This is exactly what I needed it 😄
Thanks a lot!
User | Count |
---|---|
11 | |
7 | |
5 | |
5 | |
4 |
User | Count |
---|---|
15 | |
14 | |
8 | |
6 | |
6 |