Forum Discussion
Solved
Percentage per Group
Hi experts! I have a table with the year, month and department information. In addition to that I have sales per product: Year Month Department Product Sales 2023 01 A A1 5 2023 ...
NewStep=Table.Combine(Table.Group(PreviousStepName,{"Year","Month","Department"},{"n",each let a=List.Sum([Sales]) in Table.AddColumn(_,"Percentage",each [Sales]/a)})[n])
Fowmy : Thanks, but I have posted this question within the PQ area to get it resolved using PQ.
Any further ideas?
joshua1990
Sorry about that. Please clarify you need the Percentage of sales by
Year, Month and Department ?
In this case, product will not have a break down. so your matrix should look like
| Year | Month | Department | Sales% |