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,
I have an issue with calculation groups. I've created calculation groups for P&L lines and put them to Matrix. Please have look at the snapshoot.
My problem is that when I am calculating a gap between forecast and previous forecast every data looks ok, except %Gross profit.
I would like to see here is -63,6 instead 90,9%. It's looks like calculation are based on ( Gross profit(FCT-PFCT) / Revenue[FCT-PFCT] ) instead of ( %Gross profit[FCT] - %Gross profit[PFCT] ).
Does anyone able do help?
I attached also pbix file. https://www.dropbox.com/s/5fy1u1vvpt0yie6/Calculation%20Groups%20Sample.pbix?dl=0
BR,
Marcin
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 |
---|---|
96 | |
95 | |
80 | |
74 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |