Hi, i'm looking for some help with a formula on my production planning board - i have a due date that is shown on every line the same, i also have a column (w_day)that's days it takes to produce, i'm trying to create a formula that looks at the last operation of the job (wip_order) minus the due_date by W_days (example job 002649/001 last op is 15, due date is 20/2/23, w_day = 1 new date returned would be 19/2/23) then i would like to do it for every other sequance (example sequance 14 would be the previous date 19/2/23 - w_day of 1 = 18/2/23) and so on until it gets to the sequances and workcentre called GETMAT, this is where i would take the previous date, in this case it would be 9/2/23 based on above information and only taking 10 days off all GETMAT 30/1/23 and this date 30/1/23 would show on all GETMAT sequances.
Current Power bi table
Excel sample
Sorry for the log winded question, hopefully someone can help.
Regards,
Plasticpeople
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
