Forum Discussion
Solved
MOM Change, first month excluded
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
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 )
1 Reply
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 )