Rolling periods for quarters

[Migscruz]

Hello, i need help for calculating sales rolling periods for a table with a date column that works like this:

01/03/2021 --> Corresponds to the sales of the first quarter.

01/06/2021 --> Corresponds to the sales of the second quarter.

01/09/2021 --> Corresponds to the sales of the third quarter.

01/12/2021 --> Corresponds to the sales of the fourth quarter.

I want to have the sales rolling periods like this:

Average sales of 01/12/2021 (fourth quarter) & 01/09/2021 (third quarter) vs Average sales of 01/06/2021 (second quarter) & 01/03/2021 (first quarter). I was trying to do a dax measure with dateadd function but it's not working i dont know why. 

The table is simple it's like this:

Date	Sales	Store
1/03/2021	120	A
1/06/2021	200	A
1/09/2021	300	C
1/12/2021	500	C
1/03/2021	80	C
1/06/2021	100	D
1/09/2021	90	B
1/12/2021	200	A

Thanks!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.  The total columns show you the average sales figures.

Hope this helps.

[ryan_mayu]

@Migscruz 

not clear about the description of the output. do you want to combine the avearge of two quarters?

pls see the attachment below. hope this is helpful