Add missing dates to ID as well as previous value

[Sundb]

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! 

[Sundb · Accepted solution]

The solution proposed by @Gysbert_Wassenaar  in https://community.qlik.com/t5/QlikView-App-Development/Add-rows-for-days-in-between/td-p/508008 seem to have done the trick! THANKS!

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