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 All,
Can any one help me to calculate the below formual. I need to divide the Growth %/ Revenue plan Growth %.
These two have been calculated different measure in power BI.
now i have to arrive the Variance by Dividing the below formula.(Growth% / Rev Plan Gr%)
Hi @RanjanThammaiah ,
Please try to use the formula. If it doesn't meet your requirement, kindly share your sample data and excepted result to me. Please upload your files to One Drive and share the link here.
Measure = VAR Growth = DIVIDE ( CALCULATE ( SUM ( 'Cross Domain'[MTD_TER] ) - SUM ( 'Cross Domain'[PMTD_TER] ) ), SUM ( 'Cross Domain'[PMTD_TER] ), 0 ) VAR Rev = DIVIDE ( CALCULATE ( SUM ( 'Cross Domain'[Revenue_Plan] ) - SUM ( 'Cross Domain'[PFY_TER] ) ), SUM ( 'Cross Domain'[PFY_TER] ), 0 ) RETURN Growth / Rev
Regards,
Frank
Hi @RanjanThammaiah ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
Sample data and output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |