Forum Discussion
Solved
Fill Between Date Points
Hello, The below table is filtered on one CentreCode (for ease of explanation) and shows some data. The below table illustrates what I am after, ideally I would do a transformation on Supply...
Hi JP8991,
You could refer to my sample to see whether it work or not. Use Query 1 , Query2, Merge 1 and Query3.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much for this, excellent code.
Just a few questions/tweaks.
- Would it be possible to have the newDate column go down to the current month i.e. 01/11/2019?
- Would it be possible to have the Value column cumulative so that when the 40, 100 and 148 appear the repeated values are 1377, 1477 and 1625 respectively?
- In my example I have filtered on one centre code, as you have used an index column how would I replicate this outcome when the rest of the data set is used as I am guessing the index would need to start counting from zero for each Centre Code?
Hi JP8991,
You could refer to my sample to see whether it work or not. Use Query 1 , Query2, Merge 1 and Query3.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.