Forum Discussion
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 plea...
Hi,
PBi file attached.
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]
)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 datamy 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.
