Cumulative Total Starting From 10000

[varunv11]

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

[quentin_vigne · Accepted solution]

Hi @varunv11

Can you try this ? 

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

- Quentin

[varunv11]

Hello @quentin_vigne

It works. 

Thanks 🙂

Warm Regards 

Varun Raj