Solved: Re: Calculating Sales by contract start date, wher...

Anonymous · ‎07-15-2022

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

rks · ‎07-15-2022

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.

View solution in original post

Anonymous · ‎07-21-2022

Thanks it worked.

rks · ‎07-15-2022

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.