Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
So I have this table
WeekEnding | Revenue | % | Net | Cumulative Net |
2022-11-26 | 1,107.94 | 14.8% | 164.15 | 164.15 |
2022-12-03 | 15,507.66 | 14.7% | 2,281.45 | 2,445.60 |
2022-12-10 | 45,913.69 | 14.7% | 6,740.76 | 9,186.37 |
2022-12-17 | 85,098.06 | 14.7% | 12,550.59 | 21,736.95 |
2022-12-24 | 76,295.64 | 14.6% | 11,172.44 | 32,909.39 |
2022-12-31 | 68,372.43 | 14.5% | 9,929.34 | 42,838.73 |
2023-01-07 | 80,043.82 | 14.4% | 11,522.27 | 54,361.00 |
2023-01-14 | 91,107.97 | 14.3% | 13,037.08 | 67,398.08 |
2023-01-21 | 81,853.06 | 14.2% | 11,660.92 | 79,059.00 |
2023-01-28 | 71,401.54 | 14.1% | 10,072.15 | 89,131.15 |
So the goal is to calculate Cumulative Net
To get Cumulative Net we need to get the Net first
Net = Revenue * %
Cumulative Net = is the running total of the Net
Thanks
Chris
Solved! Go to Solution.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
67 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |