I'm breaking my head over this one. I hope someone is clever enough to help me..:)
Note: - For the example below I'm using numbers instead of dates. I thought a number would be easier for the eye. - Table1 is sorted. - Both Category and Product influence how the number changes downwards. - Both Bufferdays and Holidays influence how the number changes downwards. - Holidays should always be skipped. Bufferdays should only be skipped when there is a change in Product. - Within the same Product, when there are no Holidays, +1 is the default change downwards. - To determine what is the next number downwards, first look if the next number is in Holidays, if so then skip that number. A holiday doesn't count as a buffer, so after checking Holidays always add Bufferdays, but only add them when there is a change in Product. - When for example '20' isn't filled at row 'Y;A03', then then Table1 (desired result v2) should be the desired result. In other words, the filling down should only be within each Category when a 'start value' is available for that Category. - Imagine if there was a category 'Z' with a 'start value' available, then it should do all the stuff for that category after having skipped category 'Y'.
Based on my test, I cannot achieve your goal by your data. Is there any date columns in your table? Btw, for Parameter Bufferdays, is that a Parameter table you have created in power query or a what if parameter in data model?
Community Support Team _ Frank If this post helps, then please consider Accept it as the solution to help the others find it more quickly.