Forum Discussion
Solved
Calculating cumulative Months by project code
Hi There, I am trying to calculate a cumulative monthly total (adding each months total to the previous month) and filtered by relevant project codes. I have the following headings which i am usi...
Hi,
I have now managed to create the formulas :) Thank you
The below formula seems to work; I created a sum column calculating figures by month, then created another colum to filter by project;
Monthly Sum = CALCULATE(SUM(Financials[Actual Monthly Cost]),FILTER(ALL(Financials),Financials[Date] <=TODAY()))
By Project = CALCULATE(SUM(Financials[Actual Monthly Cost]),ALLEXCEPT(Financials,Financials[ProjectCode],Financials[Monthly Sum]))
Hey,
as far as I can see the formula you provided will not work due to missing parnetheses.
I would recommend that you create some sample data, upload the pbix to onedrive or dropbox and share the link.
Regards
Tom
Many thanks Tom. I have just sent the link to your inbox.