Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jogenpatel
Frequent Visitor

QoQ calculation without date table

Hi,

 

My sample table is as below:

 

TicketsFYQtr
A2FY19Q1
A4FY19Q2
A1FY19Q3
A5FY19Q3
A33FY19Q2
A412FY19Q4
A153FY19Q1
A512FY19Q1

 

 

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
MFelix
Super User
Super User

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


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

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


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



Thanks, that worked!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.