Month over month comparison

[AquaCapriLyn]

Hello Everyone,

I am having some issues getting the Month over Month.  I know my issue is with the previous month calculation. I created variables for current and previous month. The problem is when I select a month my MoM returns a zero. I added images to show what happens when I make a selection.

Current Month

Sum({$<MonthYear ={'$(=vMaxYearMonth)'}>} Provider )

Previous Month

Sum({$<MonthYear={"$(=vPreviousMaxMonth)"}>}Provider)

Provider MoM

(   Sum({$<MonthYear ={'$(=vMaxYearMonth)'}>} Provider )
-
Sum({$<MonthYear={"$(=Date(AddMonths(Max(MonthYear),-1),'MMM-YY'))"}>}Provider)
)
/
Sum({$<MonthYear={"$(=Date(AddMonths(Max(MonthYear),-1),'MMM-YY'))"}>}Provider)

[Quy_Nguyen]

Hi, 

Since you are selecting on field createdDate.autoCalendar.YearMonth, try excluding it from the set analysis.

Or use the MonthYear field for the Dimension/Filter

[AquaCapriLyn]

Hello @Quy_Nguyen ,

I tried using it in my filter but I'm only seeing the current month not the previous month when I make a selection

[Quy_Nguyen · Accepted solution]

Hi,

I meant excluding it like this:

Current Month

Sum({$<MonthYear ={'$(=vMaxYearMonth)'}, [createdDate.autoCalendar.YearMonth]=>} Provider )

Previous Month

Sum({$<MonthYear={"$(=vPreviousMaxMonth)"}, [createdDate.autoCalendar.YearMonth]=>}Provider)

[AquaCapriLyn]

@Quy_Nguyen  Thank you!!! It worked