Adding Quarter to Quarter Values

Thanks for detailed information of the datamodel and the issue.

Im not sure how to solve your filtering issue.
Perhaps someone else knows how to solve it based on the information you provided above.

Nevertheless: you may consider simplifying your datamodel.
You have 6 tables, and it seems 4 are used only for filtering.
I guess you could
- drop the 4 tables "Ref_..."

- merge the two remaining tables
   -> Sales Table
    -> Target Table
so that you end up with only 1 table that contains both columns Sales and Target.

Use full outer join when you merge to ensure all rows from both tables are included.
If you think this approach may be beneficial for you, read more on merging here:
https://learn.microsoft.com/en-us/power-query/merge-queries-overview

Sorry for not solving the whole problem for you Hariharank04 
Kind regards.