Add missing dates to ID as well as previous value

Sundb — Sat, 16 Nov 2024 19:06:12 GMT

Hi!

I can't seem to figure this out.

I have a table (hundred of thousands of rows):

ID, YearMonth, Value1, Value2 etc.

Where YearMonth is only updated once a month IF there has been a change. Meaning, it could be a gap for 1 month up to years.

I want to add the missing YearMonths and replicate the values to "fill the gap" so to say, cause this will make it easier to build dashboards etc.

But I'm totally lost.

Appreciate your brain power!

Re: Add missing dates to ID as well as previous value

Sundb — Mon, 02 Mar 2020 14:32:12 GMT

Now I just need to figure out how to continue generating data up to Today()-1 instead of up to the last date available.