Totaling a column for a 12 month period and using in a sum

Resolved · Urgent Priority · Version 365

Fri 27 Nov 2020, 09:10 Delegate Lisa said...

Lisa has attended:
Power BI Reporting course

Totaling a column for a 12 month period and using in a sum

HI, I'm trying to work out how to get a total from a column for just a 12 month period and use in another sum.

For example. Column A (12 months total) + Column b (current total)

Is anyone able to help?

I've tried using the calculate function but it doesn't come up with the column I'm trying to use and I can't figure out why?

Fri 27 Nov 2020, 11:55 Trainer Jens said...

RE: Totaling a column for a 12 month period and using in a sum

Hi Lisa,

Thank you for the forum question.

Is it a specific fixed 12 month period or a running 12 month period? Do you have a dates table in your data model?

If you just want to add one column to another column in the same table, you can write the measure

=Sum(column 1) + Sum(column 2)

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

Training courses

	98.7 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

Explore Power BI Templates

Take advantage of Power BI templates to streamline report creation. Templates allow you to reuse custom layouts, themes, and configurations across multiple reports. Create templates for consistent branding or industry-specific reporting standards, saving time and maintaining a cohesive look across your organization's reports.

View all Power BI hints and tips