Forum Discussion
Capping a cumulative total
I'm trying to calculate a 'Realised Revenue' value by project for each month. This value should be the sum 'Cost of days' for each project, in each month, with the limitation that the total 'Realised...
The value should be £15,642.74 (which is the revenue for the project, minus the realised revenue so far, i.e. £4,233.64 + £31,552.53). I'm not sure how to get Power BI to take the revenue for the project minus the cumulative revenue last month, which is what would allow me to do the above?
echall93 ,
The value should be £15,642.74 (which is the revenue for the project, minus the realised revenue so far, i.e. £4,233.64 + £31,552.53). I'm not sure how to get Power BI to take the revenue for the project minus the cumulative revenue last month, which is what would allow me to do the above?
How to achieve £15,642.74? Could you give the calculation expression?
Regards,
Jimmy Tao