Forum Discussion

refint_650's avatar
refint_650
Helper I
4 years ago
Solved

Running total for month

Hello    I' couldnt calculate for runningtotal for year/month/orderid. i tried some power bi . In a 1st step how can i count & apply sum of Orderid's by month when year is selected and do runningt...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, refint_650 

     

    I think I can understand what you mean. Order Count is the Measure to calculate Order ID. How to calculate the cumulative summation of Order Count when Order Count is Measure.

     

    You can try the following methods.

    Maesure:

    Cumulative = 
CALCULATE (
    SUMX ( VALUES ( 'Table'[Month No] ), [Order Cou] ),
    FILTER ( ALLSELECTED ( 'Table' ), [Month No] <= MAX ( 'Table'[Month No] ) )
)

    Order Cou in my table is Measure.

     

    Best Regards,

    Charlotte Zhang

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

refint_650's avatar
refint_650
Helper I
4 years ago

attaching sample dataset. i couldnt attach excel file.

 

 

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, refint_650 

 

I think I can understand what you mean. Order Count is the Measure to calculate Order ID. How to calculate the cumulative summation of Order Count when Order Count is Measure.

 

You can try the following methods.

Maesure:

Cumulative = 
CALCULATE (
    SUMX ( VALUES ( 'Table'[Month No] ), [Order Cou] ),
    FILTER ( ALLSELECTED ( 'Table' ), [Month No] <= MAX ( 'Table'[Month No] ) )
)

Order Cou in my table is Measure.

 

Best Regards,

Charlotte Zhang

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