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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors