Need some brainpower

Hey guys,

I need your help with something I'm trying to get my head around is.

I've been asked to make a Forecast vs Realisation rapport which is based on a table with all the necessary dates in them.

I can't calculate the forecast date and I can calculate the realisation date based on the correct date field, farely simple I would guess.

The problem I'm having is that I need a date table (which I have) to link with the table in which I have my data.

Based on the column 'Civiel eind' I can transform the date to a year/weeknumber 

HP Forecast weeknummer = 
IF(
    AND(
    'Civiel/HAS planning'[activiteit]="Civiel",'Civiel/HAS planning'[eind]<>BLANK()),
    IF(
        WEEKNUM([eind])<10,
        FORMAT([eind],"YYYY-0WW"),
        FORMAT([eind],"YYYY-WW")
        )
    )

 Same goes for the HP Realisation date/week because the formula is the same except it's not based on [eind] but on [gesloten]. So basically I can calculate my reliability between forecast vs realisation.

When I put that in a visual like a Grouped Column Diagram I have to choose a column for the X-axis but when I select the column HP forecast date and I put (on the Y axis) both HP forecast and HP realisation the data doesn't match up because adresses that have been made in week 2 but are forecasted in wk 6 are shown in week 6 instead of the week they were actually realised.

That is because I put the HP forecast on the X-axis I'm guessing.