Multiple Date Relationships - How to structure these 3 tables in this condition?

[spsp]

I have a Data Structure as below, I did not create any measures to calculate sum, I want to have 2 Reposts showing 1.Total Investment Plan sold with total interest will be distributed, and 2. Future Interest distributed with Future Month.

Both tables share the same Date table, should i create 2 Date tables or how to activate the relationship for each report?

Thank you.

[lbendlin]

Joins 1 and 2 are fine.  Do not join fact tables with each other (remove the third join)

USERELATIONSHIP is used to switch a join between two tables. It does not apply in your scenario.

[spsp]

Hi, the Monthly Future Interest table is actually a further breakdown of Investment Plan table where plan_id is referrering to Investment Plan table's id column. In some circumstances I would need to perform some displays with 2 tables data. Shall I remove the relationship?

For example as below, I need to filter plan purchase_date and display them in breakdown month

Thank you