Forum Discussion

qwaiti27231's avatar
qwaiti27231
Icon for Helper III rankHelper III
7 years ago
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]...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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