Query using SumIF for a group

Hi Clive,

Thank you for the forum question and also thank you for the nice feedback.

I have attached two files to the answer. An Excel file with the source data and a Power Bi file. I have already grouped the data in the Excel file, but you can reference the Lookupvalue column you have in your model. I have used a combination of the Calculate function, Sum, and Earlier function to sum up each group.

I hope it makes sense and do what you want to do.

If you cannot see the attachments refresh your browser. If you still cannot see them. Wait 5 minutes and refresh again.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector