Calculatetable with variables

[BurtAux]

I have 2 Tables called Tour_Details :

and Contract_Details:

I would like to make a table using these two tables to make a third table Tour_summary.

Preferably using CALCULATETABLE and each column in the table Tour_summary should be a VAR.

The Column Day has the SUM of tours taking place for each SubVenue in a day,

Week has the number of tours taking place in that corresponding week.
Month, in that corresponding month and so on.

Any idea how I can achieve this?

Thanks

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...