Parallel period data by selected dates

[Noak]

Hi Guys,

can someone help me with getting sum of value of parallel period while using date filter?.

I tried to use the #parallel_period function but I think the Date filttering influnce it.

current table:

 I would like to add lParallel_Period_total (last year) column to my matrix.

[v-chuncz-msft]

@Noak,

Check if the following link helps.

https://www.sqlbi.com/articles/compare-equivalent-periods-in-dax/

[Veles · Accepted solution]

You could use a calculated measure like this:

Parallel Period = 
VAR MinDate = MIN ( Date[Column] )
VAR StartDate = DATE ( YEAR ( MinDate ) - 1, MONTH ( MinDate ), DAY ( MinDate ) )
VAR MaxDate = MAX ( Date[Column] )
VAR EndDate = DATE ( YEAR ( MaxDate ) - 1, MONTH ( MaxDate ), DAY ( MaxDate ) )
RETURN
CALCULATE ( 
	[Measure],
	FILTER ( 
		ALL ( DateColumn/Table ),
		Date[Column] >= StartDate
			&& Date[Column] <= EndDate
	)
)