MOM Change, first month excluded

[robhel]

Hello Guru's

In need of your assistance here.........I have tried a number of ways to return MOM value, excluding the starting month, however I am not getting the desired result.

I followed this post Month over Month Change Value ignore first month but it doesn't return results for every month.....Desired result is ActAmtMOM4 with first month returning 0 instead of 4019

Any suggestions welcomed

[v-frfei-msft · Accepted solution]

Hi @robhel ,

You should create a date table and update your formula accrodingly.

date = CALENDARAUTO()

Actual_Amount MoM =
VAR __PREV_MONTH =
 CALCULATE ( DISTINCTCOUNT ( table[ENO] ), DATEADD ( 'Date'[Date], -1, MONTH ) )
RETURN
 IF (
 ISBLANK ( __PREV_MONTH ),
 BLANK (),
 DISTINCTCOUNT ( table[ENO] ) - __PREV_MONTH
 )