QoQ Calculation

[qwaiti27231]

Dear all

Need help in calculating quarter over quarter 

i used  this calculation

Previous quarter= CALCULATE(SUM('Table'[value]), FILTER(ALL('calendar'),'calendar'[rank]=MAX('calendar'[rank])-1))

Latest quarter = CALCULATE(SUM('Table'[value]), FILTER(ALL('calendar'),'calendar'[rank]=MAX('calendar'[rank])))

qoq%=((Latest quarter-Previous quarter)/Previous quarter)

problem arises when there is shift from 2018 to 2019

previous quarter doesnt  fetch data require q42019 when i select q12019 

[v-yulgu-msft · Accepted solution]

Hi @qwaiti27231 ,

Not sure how you created [rank] in your calendar table. Please try below calculated columns. Then, still use above measures to calculate QoQ.

Year-quarter = YEAR([Date])*10+[Date].[QuarterNo]
rank = RANKX('calendar',[Year-quarter],,ASC,Dense)

Best regards,

Yuliana Gu

[qwaiti27231]

*previous quarter doesnt  fetch data require q42018 when i select q12019