cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
robhel Regular Visitor
Regular Visitor

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

 

MOMScreenShot.png

Any suggestions welcomed

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: MOM Change, first month excluded

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
 )
Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: MOM Change, first month excluded

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
 )
Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.