Forum Discussion
Split Table-automation
I am new to Power BI. I want to run a power query on excel spreadsheet to create tables based on distinct rows in one column. For example, the following spreadsheet
Product | Order type | price | Total Amount |
Bike | Buy | 10 | 10 |
Bike | Buy | 20 | 20 |
Bike | Sell | 10 | 10 |
Car | Buy | 10 | 10 |
Car | Sell | 100 | 100 |
Truck | Sell | 100 | 100 |
I like to split above table to have three tables Bike (three rows), Car (two rows) and Truck (one row). All new tables should have all the four columns.
I want this system to be automated. For example, if a new product is added to original table, it should create a new child table.
sa100 https://youtu.be/T1q3BF5_YJ8
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
3 Replies
Many Thanks Mahesh0016
That is a great video and it worked
I am going to be little bit greedy. Is it theoretically possible to put a variable that stores all the distinct value in "Product" column and create a loop in the function and then with just one click creates all the tables. if yes then next is how to do that.
sa100 https://youtu.be/T1q3BF5_YJ8
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
