Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I try to split one comlumn into two coulums, with less rows
I have this:
Row Column1 Column2
1 1234 0
2 ABCD 0
3 4321 1
4 DCBA 1
5 2341 2
6 BCDA 2
Want this:
Row Column1 Column3
1 1234 ABCD
2 4321 DCBA
3 2341 BCDA
Is there any way of doing this?
Thanks
Solved! Go to Solution.
Go to PowerQuery (via "edit queries")
Copy Table
Delete Alternate Rows in both
Join Tables by Column 2 into new table
Go to PowerQuery (via "edit queries")
Copy Table
Delete Alternate Rows in both
Join Tables by Column 2 into new table
I followed the solution. However I have 3 "types of rows" "Value", "SD", "Source" and I want to turn them into 3 columns. this means I had to create to copies of my original table and delete alternate rows in all three tables.
Then I joined them all in a new query by the matching column. However when I applied changes, the resulting model had all 4 tables present. Surely all this redundancy can be avoided, I would like my model to only have the final joined table in it.
However if I delete the 3 original tables, the joined table breaks because it is using them as reference.
This makes me think that I need to perform all the trasnformations within the original table if I want to avoid redundancy?
Of course, that worked very well, thanks!
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |