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
| CATEGORY | LINE | 2023 PLAN | 2024 Plan |
| MONEY | 3V | 134964 | 112500 |
| ETRAVEL | 3V | 101089 | 75817 |
| ORACLE | 3V | 1798866 | 884543 |
| PRINTING | 34 | 3060000 | 2718046 |
| PRINTING | 36 | 0 | 6500000 |
| PRINTING | 31 | 0 | 500000 |
| FUEL | 3T | -24463600 | -15529604 |
| SMART P | 3T | -723025 | -991778 |
| REVENUE | 36 | 0 | 2344350 |
| REVENUE | 3V | 207006 | 100000 |
| SOX COM | 36 | 0 | 9430460 |
| ACCOUNT | 46 | 0 | 300000 |
| ACCOUNT | 3V | 1037479 | 1106125 |
| OTHER R | 3V | 2171230 | 2099101 |
| PAYROLL | 3V | 1357019 | 1145400 |
| FUND | 3V | 45234 | 41500 |
| TRAVEL | 3V | 119842 | 96880 |
| TRAVEL | 34 | 15860 | 16000 |
| RPA | 46 | 89417 | 91300 |
| EMIN | 36 | 285000 | 8047817 |
| AUDIT T | 6W | 0 | 2500 |
| AUDIT T | 3V | 58805 | 104580 |
| CLAIMS | 34 | 7019 | 50000 |
| CLAIMS | 3V | 759026 | 993144 |
| TIMEATD | 3V | 1266551 | 1162000 |