QoQ calculation without date table

[jogenpatel]

Hi,

My sample table is as below:

Tickets	FY	Qtr
A2	FY19	Q1
A4	FY19	Q2
A1	FY19	Q3
A5	FY19	Q3
A33	FY19	Q2
A412	FY19	Q4
A153	FY19	Q1
A512	FY19	Q1

I've summarize the data by FY and Qtr with count(Tickets) as values. I want to calculate QoQ based on Qtr column. I do not have any date table.  Want to find the difference between current qtr Vs previous qtr.

thanks

[MFelix · Accepted solution]

Hi @jogenpatel ,

Looking at your data and considering you don't have a date table you can try something similar to what is below:

QoQ =
VAR CurrentQuarter =
    MAX ( Quarter_Calculation[Qtr] )
RETURN
    IF (
        RIGHT ( CurrentQuarter; 1 ) - 1 = 0;
        COUNT ( Quarter_Calculation[Tickets] );
        COUNT ( Quarter_Calculation[Tickets] )
            - CALCULATE (
                COUNT ( Quarter_Calculation[Tickets] );
                FILTER (
                    ALL ( Quarter_Calculation[Qtr] );
                    Quarter_Calculation[Qtr]
                        = CONCATENATE ( "Q"; RIGHT ( CurrentQuarter; 1 ) - 1 )
                )
            )
    )

Be aware that this is not making calculation with change of year, only quarter.

Regards.

MFelix

[jogenpatel]

Thanks, that worked!