Forum Discussion
Solved
Consolidate rows and sum
Good day PowerBI Guru. Newbe here. My data has the following layout. Goal: Remove "Line" by summing FY23, then FY 24 for each office. Then caluate % Difference and have an icon or chart ...
Based on the data you have provided, the value of sox com in 2023 is 0.
so it will returen 0
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
When I add the % Difference column to what you provided, I get the following. Is this correct? And lastly, the "SOX COM" had a zero plan in FY23 but a positive amount in FY24. Any suggestions for this one?
Based on the data you have provided, the value of sox com in 2023 is 0.
so it will returen 0
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly