Forum Discussion
Power BI % change based on columns.
Hi Anonymous ,
You could refer to my sample for details
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionAnonymous Not entirely certain, but perhaps:
New Column = DIVIDE([2020 Vol] - [2019 Vol], [2019 Vol])or perhaps just
New Column = DIVIDE([2020 Vol], [2019 Vol])If none of that helps, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hi Greg, thanks for trying to help.
That didnt seem to work. What I would do normally in excel is divide the var - eg 1,729 into the base volume of 7,825 and it would give me 22% as the change.
2020 Volume 2019 Volume Var % Change 6096 7,825 (1,729) -22% 4242 4,470 (228) -5% 
daxCommunity Support
Hi Anonymous ,
You could try below measure
Measure 2 = ABS(DIVIDE(MIN('Table'[2020 Volume])-MIN('Table'[ 2019 Volume ]),MIN('Table'[ 2019 Volume ])))Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The more I look at this more I realize there is just something not working how I want it to.
There are two products types that make up the line item that does not appear to have the correct % change on the total line. The matrix format is summing up the 11+30 and making it 40% instead of recalculating on the total. Is there somewhere I can indicate that it should calculate the % change at all total levels and not just add up the two lower level % change totals?
2020 volume 2019 Volume Volume Var Var % Total 25746 35251 (9,505) -40% should be -27% - Is summing below percentages Product Type 1 4396 4,913 (517) -11% Product Type 2 21350 30,338 (8,988) -30%