Forum Discussion
Group data in power query
Hi Adrian,
You can use an option called "Group by", which will have advanced options to calculate as per your requirement.
You can add multiple groupings along with multiple calculations as mentioned below.
Could you tell me what i would use to identify the Builder Column?
I Think i have that piece down however, when i attempt, the "Builder Colmn aways comes back with Error. I am usewr its not being identified as a value but then not sure how to identify value with words.
Could you be able to give me some sample data. I will look into it by checking the data. (You can remove or change the data if there is any confidential information)
Thankyou soo much for taking the time to look at this
Absolutley,
Sample Data below:
https://mega.nz/file/7UxxHbAK#15pI4F-LrbsUO1xWq5pfvPZTjBDB4gZz7j0tSVgqomk