Forum Discussion
How to interpolate between monthly data (Excel Power Query)
I have some historical data (approximtely 1 month apart, but newer historical may be weekly) and someone has helped to interpolate the data so we have it daily chunks, however it is stepped rather th...
Hi Ibendlin, thank you for your answer. However, it is a little different from what I am actually after. You'll see my data has unique entries for each date, which I need to keep, with the exception of the Changes Completed. That I would like to interpolate between the months (reporting periods).
Please show the expected outcome. Not clear to me from your description.