query using sumif group

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Power BI training and help » Query using SumIF for a group

Query using SumIF for a group

resolvedResolved · Medium Priority · Version 2016

Query using SumIF for a group

Hi Jens,
Can I get your help on this problem that we discussed yesterday... thanks.

RE: 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

Attached files...

Clive.pbix
Clive.xlsx

Tue 1 Oct 2019: Automatically marked as resolved.

 

Training courses

 

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Power BI tip:

Utilize Relationships Effectively

Establish clear and meaningful relationships between tables in your data model. Proper relationships enable Power BI to navigate and aggregate data accurately. Pay attention to cardinality and cross-filter direction when setting up relationships to ensure the results align with your analytical requirements.

View all Power BI hints and tips


Server loaded in 0.11 secs.