How to show QoQ growth

[harrinho]

Hi everyone, 

My excel spreadsheet includes a column Fiscal Period in the form of "Q1-2015", "Q2-2015" ETC UP TO Q4-FY17. 

I have created the following viz and I'd like to add a card which somehow will highlight the QoQ growth, from Q3-FY17 to Q4-FY17 

Would that be possible? 

[Anonymous · Accepted solution]

Hi @harrinho,

You can try to use below formula to calculate the QoQ growth, but I don't think it is possible to use card visual to highlight growth volume:

QoQ growth = 
var current_Date=MAX('Table'[Date])
var previous_Date=DATE(YEAR(current_Date),MONTH(current_Date)-3,1)
var curr=SUMX(FILTER(ALLSELECTED('Table'),FORMAT([Date],"yyyy-q")=FORMAT(current_Date,"yyyy-q")),[Amount])
var prev=SUMX(FILTER(ALLSELECTED('Table'),FORMAT([Date],"yyyy-q")=FORMAT(previous_Date,"yyyy-q")),[Amount])
return
if(prev<>0,DIVIDE(prev-curr,prev),0)

Regards,

Xiaoxin Sheng