Forum Discussion

Iculi's avatar
Iculi
Frequent Visitor
2 years ago
Solved

QoQ calculation

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

 

 

Need Help

9 Replies

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    2 years ago

    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's avatar
      Iculi
      Frequent Visitor
      2 years ago

      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's avatar
        AmiraBedh
        Super User
        2 years ago

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

    • Iculi's avatar
      Iculi
      Frequent Visitor
      2 years ago

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

      Icu