Calculating Sales by contract start date, where contract start dates differ for various customers

[Anonymous]

I am new to Power Bi, and I am trying to calculate sales using contract start date. The relationships are as below. Could you direct me to a solution please. 

Kind regards

Bhavesh Khetani

[Anonymous]

Thanks it worked.

[rks · Accepted solution]

I don't think it's possible with this model. There'S no relation between Contract Start Date and Sales. If a customer has many contracts you couldn't find a way to relate one given sale to a contract.

If you'd be able to create a Contract dimension and relate it to Sales it'd be quite simple.