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
Thank you!!!
My issues is I have some values with zeros that is resulting in an error.
Please see attached is the file.