Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Somewhat new to this, so I may not be using the correct terms. I have data like shown in Column 1 and I need to be able to show a table that would be the Return Column. So basically for the row with Marketing Finance, I need a new column that will show me a row for Marketing and a row for Finance.
Is this possible?
Solved! Go to Solution.
Hi @ERing ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) Click "transform data" to enter the power query editor -> split the column ->choose all columns -> Unpivot columns->Remove redundant columns.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ERing ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) Click "transform data" to enter the power query editor -> split the column ->choose all columns -> Unpivot columns->Remove redundant columns.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You have 3 input rows and 4 output rows. Not sure what input goes with what output. Can you put the data side by side? Is the output supposed to be in the same table as the input?
Proud to be a Super User! | |
@ToddChitt Apologies. I used the wrong example for the return column. My fact table has 3 rows and I need to be able to produce a visual that be the returns a row for Marketing AND a row for Finance from row 3.
I still don't understand how the input is supposed to translate to the output. 3 rows in, 4 rows out. Can you sketch it out in Excel, maybe, and post a screenshot?
Proud to be a Super User! | |
User | Count |
---|---|
81 | |
75 | |
74 | |
42 | |
36 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |