Last Year Set Analysis Based on Date Selection

[yossi_bire]

Hi,

I'm trying to create a calculation that based on 2 dimensions and also by the last year of the max selected date

Fields

QuarterDateStart = Starts of the Quarter ( 01/01/2018, 01/04/2018, 01/07/2018, 01/10/2018 etc)

Dim1

Dim2

This is the Calculation that i'm using for the current selection

aggr(sum({1< dim1={'con1'},dim2=$::dim2,QuarterDateStart={"$(=max(QuarterDateStart))"}>} [Measure]),QuarterDateStart)

Example

I selected 2018-Q2 , 2018-Q1

QuarterDateStart = 01/07/2018

The result that I'm looking is (the date is dynamic of course)

aggr(sum({1< dim1={'con1'},dim2=$::dim2,QuarterDateStart={'01/07/2017'}>} [Measure]),QuarterDateStart)

Thanks