RickInBellevue
asked on
In Excel Power Pivot, calculate month-over-month growth using a measure and DAX
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:
UsageMonth Consumed
1/1/2014 100
2/1/2014 110
I am thinking I should be able to create, in DAX, a measure named ConsumedPriorMonth. How do I do it?
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:
UsageMonth Consumed
1/1/2014 100
2/1/2014 110
I am thinking I should be able to create, in DAX, a measure named ConsumedPriorMonth. How do I do it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.