Is it possible to transform data from green table (image below) so they will be looking as data in the blue one?
I've tried to unpivot them, but fo course it dosent work. I dont belive in that I will need to split columns by ","... There must be some another way 😉
Maybe you have seen some tutorials regarding it?
Thanks in front for your help!
Solved! Go to Solution.
Yes, this can be achieved using power query,
Can you copy and paste the green data set in your picture as a reply?
I will share the steps as screenshots.
Thanks and regards.
First, select the column and click on the split column button in the Home ribbon, Then select by the delimiter
In the popping, window Select the delimiter as a comma and click on advance and under split into choose row radio button. Then click on Okay.
Do the same for the other column and you are done.
Mark as solutions so others can find this easily. 😄
Thanks and regards.
@mussaenda thanks for bringing this up. My belief was the rows should've done as a cross join.
Well in this case,
Since the order item and order date is in the same order we have a solution
Note: this will not work for a large data set
First, take a note of the header names then you need to transpose the data. (Button is under transform ribbon)
Since the original data set had two rows here we only have to split the 2 available columns with the comma as a delimiter to the column.
Then transpose it back to the original state. Update the header names
and do a fill down in the ID column.
This will solve the problem.
Note: if your data set has a large set of rows. This is not the ideal option since you have to split all that columns. If there is a workaround for this problem(split all the columns at once) you can use that as the ideal solution
Proud to be a datanaut.
Again thanks for @mussaenda bringing this up.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.