Match single dates to master calendar

[spcon2016]

Hi community, 

I'd like to use 2 tables in my datamodel, but I'm facing with a known issue:

ProductionStatus: 

load * inline [

date, status

01.01.2020, 1

05.01.2020,2

24.01.2020,3

];

MasterCalendar:

load * inline [

date,month,day

01.01.2020,1,1

02.01.2020,1,2

03.01.2020,1,3

[...]

31.01.2020,1,31

];

Well, my first idea was to create an additional column within my ProductionStatus table to build a rdate range and use intervalmatch as described here

Is this approach the only way or is it possible without creating an additional column? 

[fosuzuki]

What is the desired output? To have the ProductionStatus table with all dates and the status up to that date? Like:

date, status

01.01.2020, 1

02.01.2020, 1

03.01.2020, 1

04.01.2020, 1

05.01.2020,2

06.01.2020,2

...

23.01.2020,2

24.01.2020,3

25.01.2020,3

26.01.2020,3

...