Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?) .
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |