Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI % change based on columns.

I am new to power bi and am slowly learning as I go.    I have several columns brought into power BI.   Eg.   2020 Vol, 2019 Vol, Vol Variance.   I want to show the absolute volume variance w...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    You could refer to my sample for details

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

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 Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 VarVar %  
Total2574635251                     (9,505)-40% should be -27% - Is summing below percentages
Product Type 14396                      4,913                         (517)-11%  
Product Type 221350                    30,338                     (8,988)-30%