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]...
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
*previous quarter doesnt fetch data require q42018 when i select q12019