SQL Table refresh
Hello Community, need your help on this ( i am not able to attach files so pasting a sample of table) I have a table as per the below structure Run Date Region Manager supplier part spend 10-Mar-23 Region3 Manager3 Suppr2 Part3 18891 10-Mar-23 Region1 Manager1 Suppr2 Part3 10824 10-Mar-23 Region3 Manager2 Suppr3 Part2 14979 10-Mar-23 Region3 Manager2 Suppr1 Part3 15868 10-Mar-23 Region1 Manager2 Suppr3 Part3 15111 10-Mar-23 Region1 Manager2 Suppr1 Part2 19506 my organization does not grant create table access on the server so workaround is to dump the above table into Access DB which i will use to create reports in Power BI. The ask here is the owner of this table will refresh spend values for the existing dataset without altering the table structure and append data only in case a new region or a new manager or a new supplier has sent the data every before fiscal month run. the april run month table is now like this(Red ones are the new data received) Run Date Region Manager supplier part spend 10-Apr-23 Region3 Manager3 Suppr2 Part3 77036 10-Apr-23 Region1 Manager1 Suppr2 Part3 366771 10-Apr-23 Region3 Manager2 Suppr3 Part2 100775 10-Apr-23 Region3 Manager2 Suppr1 Part3 434291 10-Apr-23 Region1 Manager2 Suppr3 Part3 169688 10-Apr-23 Region1 Manager2 Suppr1 Part2 75593 10-Apr-23 Region 2 Manager4 Suppr1 Part2 340684 10-Apr-23 Region 2 Manager4 Suppr4 Part4 253959 10-Apr-23 Region 2 Manager1 Suppr4 part1 341101 10-Apr-23 Region 4 Manager2 Suppr2 Part5 28213 10-Apr-23 Region 4 Manager3 Suppr3 part1 42718 what i need is there should be some way to keep the old data table in access and a new column/table is added as per run date so that i can substract values from previous run to current run and check which region > manager> supplier> part has shown a high variance.
Conditional formatting with weeknumbers
For our planningscheme I use: a startdate, duration and endweek (Y-axis), and the weeks of the year (X-axis). If the weeknumber in the X-axis is within the start and endweek it needs te be coulored. This far I am able to do this. The problem starts when the planning goes to the next year. From that point the weeknumbers start over from 1. But my created formula only understands the colouring until week 52. How do I need to make the conditional formatting to show all the right colours according to our planning?