Forum Discussion
Consolidate rows and sum
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
Do you mean that you want to add a new column in the table to calculate the difference?
If you want to achieve it, you can refer to the following calculated columns.
Sum_2023 = SUMX(FILTER('Table',[CATEGORY]=EARLIER('Table'[CATEGORY])),[2023 PLAN])Sum_2024 = SUMX(FILTER('Table',[CATEGORY]=EARLIER('Table'[CATEGORY])),[2024 Plan])%Difference = DIVIDE([Sum_2024]-[Sum_2023],[Sum_2023])Output
If you want to implement it by using measure, you just put the CATEGORY to the row field to the matrix, and put the 2023 plan and 2024 plan to the value, it will automatic aggregate. then follow the soution I offered at 4th message to create the measure.
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