cancel
Showing results for
Did you mean:
Highlighted
jogenpatel Frequent Visitor

## QoQ calculation without date table

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

1 ACCEPTED SOLUTION

Accepted Solutions Super User

## Re: 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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

2 REPLIES 2 Super User

## Re: 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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

jogenpatel Frequent Visitor

## Re: QoQ calculation without date table

Thanks, that worked!