Forum Discussion
sa100
3 years agoHelper I
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 p...
- 3 years ago
sa100 https://youtu.be/T1q3BF5_YJ8
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
sa100
3 years agoHelper I
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
3 years agoSuper User
sa100 https://youtu.be/T1q3BF5_YJ8
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!