Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
86 | |
77 | |
70 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |