I am trying to create a calculation and stuck in between. Hope any one could guide me to arrive at the desired results.
Below are list of data source I am using:
1) Primary Data Source: Below is the screen shot for your reference.
Under Requested week 201826: Snapshot week 201822 and 201823 are missing.
Under Requested week 201825: Snapshot week 201822 is missing.
Since I am doing all the calculations at row level. I cannot afford to have missing data. Hence I create an additional data source for all the missing weeks and did a cross data base join.
2) Missing weeks Data source : Below is the screen shot for your reference.
Post joining the data I have all the missing columns in the data.
To identify the part type I blend my primary data source to another data source named Part Type Details.
3) Part Type Details:
Everything goes well. But I see NULL for the missing weeks and I hit a roadblock to get the desired results.
As I mentioned earlier I am doing a row level calculation using Table Calculations. Is there any function we could write to Show MTS even in Missing weeks, I have just highlighted week 201822 and 201823 for your reference.
In any of the snapshot weeks if we have MTS could we replicate the same where we have NULL. All I need is MTS in the entire "Part type" column.
I have attached the TWBX file for your reference. And help solving this will be greatly appreciated.
The lack of any data related to these days makes supplying the Part Number and Part type a challenge. What should the values be in this sample data be in the data? I do not see anything in the data that would provide this information.