Quarterly Growth Calculation

[mapman1980]

Hello!

I'm calculating the average growth rates of some sale values for each quarter. I had to convert the quarters into numeric values to get it to work though. 

Here is the measure I used:

Growth Rate from Average Sales =

VAR CurrentQuarter = MAX(Assets[Quarter])

VAR CurrentQuarterSales = CALCULATE(AVERAGE(Assets[Sales]), Assets[Quarter] = CurrentQuarter)

VAR PrevQuarter = MAX(Assets[Quarter]) - 1

VAR PreviousQuarterSales = CALCULATE(AVERAGE(Assets[Sales]), Assets[Quarter] = PrevQuarter)

RETURN

IF(ISBLANK(CurrentQuarterSales) || ISBLANK(PreviousQuarterSales), BLANK(), DIVIDE(CurrentQuarterSales - PreviousQuarterSales, PreviousQuarterSales))

Here is the data:

Sales	Quarter	Qlabel
454	4	Q4 2022
326	4	Q4 2022
542	3	Q3 2022
542	4	Q4 2022
653	3	Q3 2022
553	2	Q2 2022
535	2	Q2 2022
554	2	Q2 2022
553	1	Q1 2022
985	4	Q4 2022
696	4	Q4 2022
662	4	Q4 2022
366	3	Q3 2022
365	1	Q1 2022
665	4	Q4 2022
363	3	Q3 2022
352	1	Q1 2022
233	4	Q4 2022
352	1	Q1 2022
524	2	Q2 2022
235	4	Q4 2022
241	3	Q3 2022
545	1	Q1 2022
658	3	Q3 2022
654	4	Q4 2022
354	3	Q3 2022
365	4	Q4 2022
1000	1	Q1 2022
545	3	Q3 2022
985	2	Q2 2022
654	1	Q1 2022
354	1	Q1 2022

When I turn it into a visualisation it shows the quarter as a number (1 instead of Q1 2022). Is there any way of calculating the growth and then in the visualisation showing the % growth against the quarter as written in the Qlabel column (Q1 2022)?

Here is the visualisation currently. the row marked as "4" is the growth from Q3 2022 to Q4 2022.

[johnt75 · Accepted solution]

Set up a proper date table, marked as a date table, and you can use

Growth Rate from Average Sales =
VAR CurrentQuarterSales =
    CALCULATE ( AVERAGE ( Assets[Sales] ), DATESQTD ( 'Date'[Date] ) )
VAR PreviousQuarterSales =
    CALCULATE (
        AVERAGE ( Assets[Sales] ),
        DATEADD ( DATESQTD ( 'Date'[Date] ), -1, QUARTER )
    )
RETURN
    IF (
        ISBLANK ( CurrentQuarterSales ) || ISBLANK ( PreviousQuarterSales ),
        BLANK (),
        DIVIDE ( CurrentQuarterSales - PreviousQuarterSales, PreviousQuarterSales )
    )

[mapman1980]

Thank you very much, that works perfectly and just as intended.