Calculating Growth vs Qtr of previous yr in one table (Q1 CY vs Q4 LY)

[Anonymous]

Hi, 
So I have a sales table and date table. I want to summarize the quarterly growths vs the same quarter in previous years + I want to calculate the QoQ growth (all in one table).
The format is as in table below. What I am struggling with is calculating the growth in Q1 vs Q4 of previous year. How do I make a measure that does that?

Year Filter:

20XX

Q1

Q2

Q3

Q4

vs Y-1

vs Y-2

vs Y-3

vs LQ

vs Y-1

vs Y-2

vs Y-3

vs Lq

vs Y-1

vs Y-2

vs Y-3

vs Lq

vs Y-1

vs Y-2

vs Y-3

vs Lq

Brand A

Brand B

Brand C

[amitchandak · Accepted solution]

@Anonymous , You can use Time intelligence with help from Date table

example

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))

Qtr Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(ENDOFQUARTER('Date'[Date])))

Last QUARTER Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD( ENDOFQUARTER(dateadd('Date'[Date],-1,QUARTER))))
Last QUARTER Sales = CALCULATE(SUM(Sales[Sales Amount]),PREVIOUSQUARTER(('Date'[Date])))

Last to last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-2,QUARTER)))

trailing 4 QTR = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-4,QUARTER))

trailing QTR = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,QUARTER))

Last Year same QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-4,QUARTER)))

Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0

[Anonymous]

Hi @amitchandak ,
Thank you for your response.
I have tried dateadd type measures, but they are not working. I think probably because of the Year filter on the page & quarter fiter in the table column. I need a measure to overcome this. 
I m getting results for all columns except for 'Q1 of current yr vs Q4 of previous year' column.