EDIT 2020-12-14: if you are looking for the perfect mathematical formula and the DAX necessary to implement PVM, please go the latest post/video in this series – DAX for Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial)
In the Part I of this series, I mentioned that I was cutting some corners with my calculation for the sake of giving you a simple and performant formula that was “good enough”. Well, what if it is not good enough and you will not settle for anything other than the perfect math???
Well, the good news is that it took me half the time of the Part I Video to cover the perfect formula in the video for the Part II. It takes a few more steps and it will take a bit of performance out of your reports, but this guide would not really be The Definitive one if I did not give you the perfect calculation, would it???