Query on Power BI report regarding relationships

Hi there,

I have a dataset based on Hours for FY25, the Cost for FY25 and bulk dispatch for the year FY25 also.

I’m looking to create a working relationship between the three tables in order to get the labour cost per hours for litres dispatched.

I have an attempt attached where I created a new calendar table and created a Pay Week Ended calculated column within the calendar table also. The pay week ends on a Tuesday in my data, so Tuesday the second of July for example.

I created the relationships but for some reason Power BI isn’t recognising some of the operation amounts from the Bulk Dispatch table.

Can somebody help me in my query. I want to fix the relationship and essentially get the labour cost per hour per bulk dispatch (from the three tables).

I created the calendar table as it was all transactional data so couldn’t create proper relationships.

Please see attached the files:

PBIX File - https://drive.google.com/file/d/1FZVtikO_zcAeMQNyB0AN4_MM8w6CKy0s/view?usp=sharing

Excel - https://docs.google.com/spreadsheets/d/1Fqk0xjlmGSrpY0T4I8GVIztem3sQ8EG7/edit?usp=sharing&ouid=116472822422825040168&rtpof=true&sd=true

Any help would be greatly appreciated.