Forum Discussion

varunv11's avatar
varunv11
Frequent Visitor
8 years ago
Solved

Cumulative Total Starting From 10000

Hello, 

 

I am trying to creating a running total which starts from 10000 and the creating the running total based on profit or loss. 

 

Sample screenshot given below, 

 

 

Please advise. 

 

Warm Regards 

Varun Raj

Need Help
  • quentin_vigne's avatar
    quentin_vigne
    8 years ago

    Hi varunv11

     

    Can you try this ? 

     

    Cumulative sales = 10000 + 
CALCULATE (
    SUM ( 'YourTable'[P/L] ),
    ALL ( 'YourTable)' ),
    'YourTable'[Time] <= EARLIER ( 'YourTable'[Time] )
)

     

     

    - Quentin

2 Replies

  • quentin_vigne's avatar
    quentin_vigne
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hi varunv11

     

    Can you try this ? 

     

    Cumulative sales = 10000 + 
CALCULATE (
    SUM ( 'YourTable'[P/L] ),
    ALL ( 'YourTable)' ),
    'YourTable'[Time] <= EARLIER ( 'YourTable'[Time] )
)

     

     

    - Quentin