Issue with data modelling

[Jameswh91]

Hi, I'm having a few issues with my data model. It appears that there's no relationship between the reviews, the returns fact table and the sales table. Would i need a bridiging table berween them?

Many thanks in advance for any help received.

 

[jsaunders_zero9]

What is the relationship between reviews and sales/returns table? Does each sale/return only have 1 or less reviews?

[Jameswh91]

Hi, so they are all related to the date and product table. I'm hoping to show the return rate but the returns figure doesn't adjust with the date.

[Anonymous]

Hi @Jameswh91 ,

According to your statement, I think there is an active relationship between Return table and Date table. How did you create [Return Rate]? Is it a column or a meausre? Please tell me more details about the calculation about [Return Rate]. 

You can share a sample file with me and show me a screenshot with the result you want. 

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.