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?