Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Related tables and forcasting

Hello all,   I have 2 tables which are related in a Many to 1 by Contract name.      Sales (Many)  = A list of sales to multiple customers with these important columns Sales number Contract ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Jihwan_Kim 

 

Yeah that's roughly how simple I thought it would be.  I thought it would be

Daily_Average * RELATED(ContractDate[Days until contract ends])

 

But the measures simply won't allow me to add the Days Until contract ends field in there which is why I am stuck.  I can use it in column calculations, but not measures.   Any ideas on what might be happening?

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Anonymous 

Thank you for your feedback.

I am not sure how your data model looks like, but please check the relationship between the two tables.

Or, if it is OK with you, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.

 

Thanks.