Forum Discussion
Create table from existing data set in power query excel
Hello 10500438
Select every column except the last one --> Tranform --> Group by
Set the group by like this
change the formula in the formula bar the part of the funciton like this
each List.Product([Unit Yield])
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello 10500438
Select every column except the last one --> Tranform --> Group by
Set the group by like this
change the formula in the formula bar the part of the funciton like this
each List.Product([Unit Yield])
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
All though I can get this to work on the numeric columns, grouping by sales order and sales item, I cannot get it to work when I group by all the columns shown, I am getting a DataFormat.error we couldn't convert to a number Details 1P01780000.
Any thoughts as to why? Maybe because the Column Mill Area is text characters?
I figured out I needed to change the type to numeric,, thank you!! It works great!!
Thank you for all your help so far!!