QoQ calculation without date table

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