cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Simon_29
Helper I
Helper I

Addition of several records from different years into one line

Hello.

I would need to make such an output from this table that I only have 2019, 2020 and once 2021 left in the FYSCAL_YEAR column, and that the SUM column will make the sum for those years from all the records. Thus, in total there will be only 3 rows and at the end of them will be the sum of all values ​​from the SUM column for the year 2019, 2020, 2021.
I'm sending a screenshot of what my spreadsheet looks like.
project_help.png

Thank you very much for all the help.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@Simon_29 Seems like you want to right-click your FISCAL_YEAR column and do a Group By?


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@Simon_29 Seems like you want to right-click your FISCAL_YEAR column and do a Group By?


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

Thank you. It was that: D

Can I Make Several Group By In One Query? That could be done, for example, Group By based on FYSCAL_YEAR, but also, for example, PRODUCT_NAME or PLATFORM. Similar to the Pivot Table, where there are several criteria.

well thank you

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors