Forum Discussion
Solved
QoQ Calculation
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
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
2 Replies
*previous quarter doesnt fetch data require q42018 when i select q12019
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
