compare two periods in a dynamic way

[shimona]

Hello,
I'm trying to create the next view
In my model I have to compare two periods in a dynamic way
When in each period there are years, quarters, and months
For example, in the first period I choose 2016 in the second period 2017
In the table I should see the following result
[Sales2016], [Sales2017], [(Sales2016) - (Sales2017)]

How can the model be built to have independent Date tables and the data can still be compared?

Thanks.

[vanessafvg]

@shimona there are other ways to compare data, what exactly are you trying to do?

for example you can derive previous year values or year - ? value..

what exactly are you trying to see by comparing 2 disconnected data sets, essentially they would need to be disconnected i would think otherwise they would filter the other

[shimona]

thank you for the quick reply,

I need to compare a summary of two values that depend on the period
For example, the third quarter of 2015
         Compared to 2017 Q1

       (the selection should be dynamic)
      And then calculate the ratio between them
The table should contain 3 columns
 sumQ3_2015, sumQ1_2017,(sumQ3_2015 / sumQ1_2017)

How i create model with two calander table Without filtering each other.