Merge two table with two dates

[Guillaume_S]

Hi, 

I want to merge two tables with a calculation.

A table has three columns (one column is the contract number, one is the start of the contract and the last is the end of the contract)

The second table is a calendar table. (a column with all the dates and one with a period)

I want to merge the two to have a result like this.

My tables :

I wish i had a table with this result : 

With the contrat 25, 3 lignes because the contrat spend 3 months and the number one for the sum

Does anyone have the solution ?

Regards

[amitchandak · Accepted solution]

@Guillaume_S , refer these solutions

Between Dates - Dates between
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

Tables way
https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2