cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DeskServices Frequent Visitor
Frequent Visitor

Cumulative sum per Year - Countdown

Hi everyone, 

 

I'm looking for a solution to create a calculation to sum the cumulative results Per Year for a countdown column.

Hereby an overview of (fake) numbers per Year by the Countdown column. The cumulative calculation needs to start by the highest number and needs to sum all the numbers till the lowest number in the column (WeeksUntil). As the column is a countdown.

8 REPLIES 8
Super User
Super User

Re: Cumulative sum per Year - Countdown

@DeskServices Please share data in excel using onedrive/google drive to get your answer quickly. Remove any sensitive information before sharing.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





DeskServices Frequent Visitor
Frequent Visitor

Re: Cumulative sum per Year - Countdown

Hi @parry2k ,

 

Hereby a link to a sample table stored in Google Drive.

 

I've added the actual table and the requested cumulative sum per year.

 

Would be great if you're able to help me!

 

Thanks

Super User
Super User

Re: Cumulative sum per Year - Countdown

@DeskServices solution attached, I have to unpivot your data it to work. Look at power query steps






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





DeskServices Frequent Visitor
Frequent Visitor

Re: Cumulative sum per Year - Countdown

Thanks @parry2k, but doesn't seems like it's fully working, unfortunately. 

 

When I use your calculated measure in my dashboard, with actual source data, seems like there are still a few differences in the cumulative column...

Super User
Super User

Re: Cumulative sum per Year - Countdown

@DeskServicesyou have to be very specific what is not working otherwise I have no way to know this.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





DeskServices Frequent Visitor
Frequent Visitor

Re: Cumulative sum per Year - Countdown

@parry2k , there's another field which need to taken in account when you filter on it. There are 7 types of qty, we would like to filter on the results per type as well. For now, the field 'Type' isn't taken  into account. So, when there's a week with no qty for a specific type, there's a zero or it's not listed in the table now, so the qty goes down or is being calculated wrong.

 

Here's the link to the file with the additional field added. 

 

 

Super User
Super User

Re: Cumulative sum per Year - Countdown

@DeskServices another field surely plays a role on dax, how you are planning to visualize






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





DeskServices Frequent Visitor
Frequent Visitor

Re: Cumulative sum per Year - Countdown

@parry2k 

As you can see in the link it's like a subcategory field. I would prefer to overview the data by total, but would like to filter on a subcategory level as well. But when I filter or select a subcategory, the data is incorrect now. 

 

Do you've a suggestion?

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)