topic Re: Seemingly simple Excel task about Mth-to-Mth change, but really need DAX help in DAX Commands and Tips

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

ewu — Mon, 06 Mar 2023 06:00:54 GMT

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!

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

DAXDigger — Mon, 06 Mar 2023 07:49:23 GMT

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)

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

ewu — Wed, 08 Mar 2023 00:38:07 GMT

Thanks so much!