Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |