Power BI & DAX Tutorial: How to Implement Allocations

If you are in FP&A and trying to understand profitability of your products/business units, you have had to face a challenge of allocating certain corporate/HQ expenses. In this tutorial I go over the steps of implementing allocations in Power BI: Desktop file location: https://bit.ly/3dOUTNV The calculations below are used in the tutorial: Rent = CALCULATE ( SUM ( GL[Amount] ), KEEPFILTERS ( GL[Account] = "Rent" ) ) Amount with Allocation = … Continue reading Power BI & DAX Tutorial: How to Implement Allocations

Price Volume Mix (PVM) for Gross Margin Variance Analysis

I have covered Price Volume Mix (PVM) analysis for Revenue Variance in the earlier article. I recommend that you take a look at it first because PVM for Revenue variance analysis is much easier to understand as there are fewer moving parts to think about in the calculations. Assuming that you are now well versed … Continue reading Price Volume Mix (PVM) for Gross Margin Variance Analysis