Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi @varunv11
Can you try this ?
Cumulative sales = 10000 + CALCULATE ( SUM ( 'YourTable'[P/L] ), ALL ( 'YourTable)' ), 'YourTable'[Time] <= EARLIER ( 'YourTable'[Time] ) )
- Quentin
Hi @varunv11
Can you try this ?
Cumulative sales = 10000 + CALCULATE ( SUM ( 'YourTable'[P/L] ), ALL ( 'YourTable)' ), 'YourTable'[Time] <= EARLIER ( 'YourTable'[Time] ) )
- Quentin
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |