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...
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

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

  • varunv11's avatar
    varunv11
    Frequent Visitor
    8 years ago

    Hello quentin_vigne

     

    It works. 

     

    Thanks :)

     

    Warm Regards 

    Varun Raj