- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Calculated Column- Adding up Total per Month
I'm trying to create a column that shows the monthly totals next to each line in the month.
This is what I want it to look like:
This is how the two tables are joined:
This has been my best guess:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

hello @bonjourposte
please check if this accomodate your need.
1. create calculated column for month number
2. create calculated column for calculating sum of number
Desired Monthly Total =
SUMX(
FILTER(
'Table',
'Table'[Month]=EARLIER('Table'[Month])
),
'Table'[BMAX]+'Table'[DE]+'Table'[HDIF]+'Table'[HDIV]+'Table'[HMAX]+'Table'[HYLD]+'Table'[ZWC]
)
Hope this will help you.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Please provide data we can work with - preferably your data file.
How is it 'not working'? I can't tell what you expect the result to be - please show an example of the result you want.
Regards
Phil
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
Blog :: YouTube Channel :: Connect on Linkedin
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sorry I should've highlighted the last column. I want the results in the last column like this:
Does that help? I just keep getting #ERROR messages.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

hello @bonjourposte
please check if this accomodate your need.
1. create calculated column for month number
2. create calculated column for calculating sum of number
Desired Monthly Total =
SUMX(
FILTER(
'Table',
'Table'[Month]=EARLIER('Table'[Month])
),
'Table'[BMAX]+'Table'[DE]+'Table'[HDIF]+'Table'[HDIV]+'Table'[HMAX]+'Table'[HYLD]+'Table'[ZWC]
)
Hope this will help you.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks, it worked, I never thought of EARLIER. I have two July entries from two years, so they added together, so I combined the month/year columns and it worked.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-24-2024 05:40 AM | |||
03-14-2024 10:32 PM | |||
01-02-2024 08:44 PM | |||
Anonymous
| 06-18-2018 10:02 AM | ||
03-26-2024 04:18 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |