Seemingly simple Excel task about Mth-to-Mth change, but really need DAX help

[ewu]

Really appreciate help - how do I go from the top 2 tables to get the results of the table at the bottom?

Basically it is just a month-to-month change in value, but ... DAX is hard...

Thanks a lot!

[DAXDigger · Accepted solution]

Measure = 
VAR _currentRevenue = CALCULATE(SUM(Customer[Revenue]))
VAR _selectedDate = MAX(Customer[Month])
VAR _prevDate = CALCULATE(MAX(Customer[Month]),Customer[Month]< _selectedDate)
VAR _prevRevenue = CALCULATE(SUM(Customer[Revenue]),ALL(Customer[Month]),Customer[Month]=_prevDate)
RETURN IF(_prevRevenue = 0 ,1, (_currentRevenue - _prevRevenue)/_prevRevenue)

[ewu]

Thanks so much!