Forum Discussion

Zaky's avatar
Zaky
Icon for Helper IV rankHelper 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
Icon for Community Support rankCommunity 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
Icon for Helper IV rankHelper 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