In Excel Power Pivot, calculate month-over-month growth using a measure and DAX
Posted on 2014-04-22
In my Excel Power Pivot table I have a couple columns:
UsageMonth (date datatype)
Consumed (float number)
I want to calculate month-over-month growth. For example, if in January I consumed 100 and in February I consumed 110, 110/100-1 equals .10 or 10% growth.
If my table has this data:
I am thinking I should be able to create, in DAX, a measure named ConsumedPriorMonth. How do I do it?