Forum Discussion

Zaky's avatar
Zaky
Helper IV
5 years ago
Solved

Accumulative Running Total

Hi Experts, If anyone could help me to get accumulative running total. Firstly, i created the following new column measures to count rows of Status Table "Returned" by weekly. 1) Start Month = STA...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    Hi Zaky ,

     

    Do you want to calculate the cumulative value for the whole year or recalculate the cumulative value from the beginning of each month?

    You can refer the following measures,

     

    Accumulative1 = 
CALCULATE([Your measure],FILTER(ALLSELECTED('Date'),'Date'[Date]<=MAX('Date'[Date])))

     

    Accumulative2 = 
CALCULATE([Your measure],FILTER(ALLSELECTED('Date'),'Date'[Date]<=MAX('Date'[Date])&&'Date'[Month name]=MAX('Date'[Month name])))

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    BTW, pbix as attached.

v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
5 years ago

Hi Zaky ,

 

Do you want to calculate the cumulative value for the whole year or recalculate the cumulative value from the beginning of each month?

You can refer the following measures,

 

Accumulative1 = 
CALCULATE([Your measure],FILTER(ALLSELECTED('Date'),'Date'[Date]<=MAX('Date'[Date])))

 

Accumulative2 = 
CALCULATE([Your measure],FILTER(ALLSELECTED('Date'),'Date'[Date]<=MAX('Date'[Date])&&'Date'[Month name]=MAX('Date'[Month name])))

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

BTW, pbix as attached.

  • Zaky's avatar
    Zaky
    Helper IV
    5 years ago

    Hi v-zhenbw-msft,

     

    Thank you for your response.

    My expected result like the table below where I filter the value data for Returned status starting from July. From there, I want to get accumulative running total.

     

    For example: Starting Week 2 of July, total value for status Returned is 339 and so on. While for Accumulative running total for Returned, I want the value to calculate each week like 339 (week 2) + 158 (week 3) = 497 , 497 (week 3) + 102 (week 4) = 599 and so on...

    BTW, pbix link provided here for you to better understand what is my requirement.

     

     

    Thanks.

  • Zaky's avatar
    Zaky
    Helper IV
    5 years ago

    v-zhenbw-msft 

    Finally... it's works as per my expectation! ‌‌😍
    In addition, any chances to change the value of column Week which start with numbering/week "1 Week" to Week/numbering "Week 1"?

     

    Btw, thanks a lot bro! It was a relief when we managed to complete the challenge.

    Thumbs up ‌‌👍

     

    Here's the results