What I want to do here is this, I have 3 years worth of data and what to compare costs in any given month.
How do I get create a calculated column that will be the difference of Cost Per Kg (in the right) - Cost Per Kg (in the left)
So in the example below, I would want have a column there that would be called Cost Per Kg (difference)
Row 1 will then be 15.66-15.74
Solved! Go to Solution.
Just add a new measure like this
CostPerKgExpression - Before(CostPerKgExpression)
Make sure to replace the CostPerKgExpression above with the expression you have for CostPerKg..
Does this make sense?
Cost Per Kg is actually Cost/Weight.
When I added measure of Cost Per Kg Delta with Expression: ceil( Sum([Total Amount])/Sum([Actual Weight]),0.01)-Before(ceil( Sum([Total Amount])/Sum([Actual Weight]),0.01))
The other month would not show up, this is how it looked like