Power Query drawing through Calendar Data OK but Pivot Table shows incorrect values

I've created a data model using 2 tables - tbl_calendar and tbl_Delivered_Revenue
The model is ANALYSIS.xlsx

I've created bespoke date columns based on the date range in tbl_calendar to form meaningful headers - Trading Year / Trading QTR / Trading Month as gregorian calendars dates are not the financial trading periods.

This seems to work OK and i've input a relationship between Date (ACTUAL) from tbl_calendar to Start Date from tbl_Delivered_Revenue.

I've created a simple pivot table using the data model and have Year / QTR Name / Month Name in the Rows which display fine - the issue is when i drop the Value field into [Values] it doesn't list the actual trading month revenue values, just gives me a sum total of ALL of the Value not by tradiong month.

SAMPLE_IMG.png

SAMPLE2_IMG.png

Let me know if you can see where i've gone wrong with this model.

Thanks