Split Table-automation

[sa100]

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.

[Mahesh0016]

Hello @sa100 ,

Good morning

see this video i hope is helpful....

https://youtu.be/Tnw77rpm-BQ

[sa100]

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.

[Mahesh0016 · Accepted solution]

@sa100 https://youtu.be/T1q3BF5_YJ8
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!