QoQ calculation

[Iculi]

Hi,

How can I create measure to calculate QoQ% i already have this PQ or Actual Q measure which is 2,173 but i don't know how can is create the previous quater data which is 1,930.. 

Could you please help me?

Thanks,

Icu

[Ashish_Mathur · Accepted solution]

Hi,

PBi file attached.

[Iculi]

Thank you Ashish Mathur! It's very helpful and i learned again something new! 🙂

Icu

[Ashish_Mathur]

You are welcome.

[AmiraBedh]

I suppose that you have a date column in your dataset.

To calculate the total for the previous quarter:

Previous Quarter Total = 
CALCULATE (
    SUM ( 'Table'[ColA] ),
    PREVIOUSQUARTER ( 'Table'[DateColumn] )
)

Then :

QoQ % Change = 
DIVIDE(
    [Current Quarter Total] - [Previous Quarter Total],
    [Previous Quarter Total]
)

[Iculi]

Hi Amira,

unfortunately it is not good.

current Q total measure is: 

= CALCULATE([LOIs],(PREVIOUSQUARTER(DATESQTD('EU-A KPIs  PBi-2024'[Commission Month]))))

this measure result is 2,117, which incl 2024 Jan+2023 Dec+2023 Nov data

my problem is that, how can i create previous quater data which incl the previous 3 month data, currently Aug-Oct 2023 and this data should be 1,930. 

[AmiraBedh]

Can you please share your initial table ?
and then the expected output ?

[Iculi]

Commission Month	LOIs
Jan-23	390
Feb-23	724
Mar-23	685
Apr-23	693
May-23	684
Jun-23	748
Jul-23	649
Aug-23	653
Sep-23	838
Oct-23	439
Nov-23	1,319
Dec-23	359
Jan-24	495

Mom%	QoQ%	YoY%
37.9%	12.6%	26.9%
Actual Q	2,173
PQ	1,930

[lbendlin]

You can use Quick Measures for this

[AmiraBedh]

Can you please share the formulas you are using for each measure?