% Difference from the previous quarter

Hi Van , sorry If I'm not explaining this clearly - I'm a beginner with Power BI. So,

1. The target table is where a user records what the monthly, quarterly or yearly target is against a metric name i.e., for metric name "No. of schools opened" there are 4 records (rows) which shows the quarterly targets for Q1, Q2, Q3 & Q4. This is calculated through the 'Period' column which is a date data type. 

2. The report table is where users go and report on their quarterly targets i.e., for metric name "No. of schools opened" the target for Q1 was 10, they have achieved 12 etc. The report and target table have a 1:1 relationship because one report can only have one target, and one target can only have one report against it. 

3. The calendar table was created to understand what the finanial year, quarter and month was from the 'Period' column in the target table. The target and calendar table have a Many to one relationship because a target can only have one date, however a date can have many targets.

You mention you would link the below, however the date column is in the target table because thats where the quarterly, monthly or yearly targets are set.

• calendar should be connect to report separately
• calendar should be connected to target separately  

If I do need to do what you've suggested, how do I do this please? Do I need to add the 'Period'' (date) column in the report table?