98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Totaling a column for a 12 month period and using in a sum
Totaling a column for a 12 month period and using in a sum
Resolved · Urgent Priority · Version 365
Fri 27 Nov 2020, 09:10Delegate 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:55Trainer 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
|
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Explore Power BI TemplatesTake 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. |
