March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi everyone,
i really need your help. i have set of data with repeated column every 8 columns. I would like to move 21 rows of every 8 column under the row of the first set of data.
Any ideas how i can solved this problem?
Thanks
Solved! Go to Solution.
Hi @dannytan111289 ,
As in power bi ,we cant index columns directly,from my point of view,I would recommend you that first duplicate table then remove columns respectively.
Take below table for example:
Split the table into 2 tables as below:
Then rename the column names in the second table to keep the same with the first one:
= Table.RenameColumns(Table.RenameColumns(#"Removed Other Columns",{"Phone","CustomerID"}),{"Sex","Name"})
In the last step,using append to get your expected output:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Hi @dannytan111289 ,
As in power bi ,we cant index columns directly,from my point of view,I would recommend you that first duplicate table then remove columns respectively.
Take below table for example:
Split the table into 2 tables as below:
Then rename the column names in the second table to keep the same with the first one:
= Table.RenameColumns(Table.RenameColumns(#"Removed Other Columns",{"Phone","CustomerID"}),{"Sex","Name"})
In the last step,using append to get your expected output:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Please provide sample data in usable format (not as a picture - maybe insert into a table?) .
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
165 | |
116 | |
63 | |
57 | |
50 |