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 ,

 

We have checked your pbix file and we have a little confused.

Why the week 2 is 339 in your screenshot, but in your table visual, the week 1 is 339.

Maybe you can refer this measure.

 

Measure = CALCULATE([MeasureReturned],FILTER(ALLSELECTED(Data2020),Data2020[Batch Return]<=MAX(Data2020[Batch Return])))

 

 

If you have any question, please kindly ask here and we will try to resolve it.

 

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.