Forum Discussion
minus from cumulative
Hi Anonymous
You may refer to below post. If you need further help, please share the .pbix file for us to provide an accurate solution.You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
https://community.powerbi.com/t5/Desktop/Cumulative-sum-of-a-measure/td-p/270358
Regards,
Cherie
How are you minusing off past staff? Can you post that formula?
Sample data would help tremendously but I am guessing that it has something to do with your past staff only being in "scope" for that first set. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi thanks for the reply. I think your right about the scope, however even if I type in minus 7 it only takes it off the first week so I need to write something that repeats the process. the past staff formula is below, it simply works out the full time days worked including overtime over the last 5 weeks. Labour(2) is not linked to the date that the rest of the sheet uses.