Forum Discussion
Grouped Performance Evaluation
In Power Query, use the Group By on Proj Number with 3 aggregations (Sum Budget, Sum Cost and 'all rows' )
You can then add a column to divide cost/budget. Then add another column using this to get the bucketing (if..then.. else).
You can then expand the 'all rows' to return the stage details (from the column header)
In Power Query, use the Group By on Proj Number with 3 aggregations (Sum Budget, Sum Cost and 'all rows' )
You can then add a column to divide cost/budget. Then add another column using this to get the bucketing (if..then.. else).
You can then expand the 'all rows' to return the stage details (from the column header)
Thank you for your assistance. Your response has steered me in a direction which allowed me to achieve the desired end result.