Forum Discussion

edavila's avatar
edavila
Icon for Helper II rankHelper II
9 years ago

Relationship with Material Table and Date

Hello everybody and thanks for helping   Im trying to do a sales YTS table to compare year over year and also display the family of the product, cases, amounts, etc.   the amounts and cases are o...
Need Help
Show and Tell
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi edavila,

Have your resolved your issue? According to the relationship between tables, you can load the Brand in 'SalesYTD' table using RELATED(Material[Brand]). If you want to drag the brand form 'SalesYTD' table, you need to calcute it using aggregated function becuase the many to one(other tables) in your resource table.

 

In addition, would you mind post your .pbix file forther analysis?

Best Regards,
Angelia