MoM error

[Nimai123]

I have a measure of MOM growth created 

Last Month GRS = CALCULATE( [GRS Distinct count] , DATEADD( 'Date Table'[FullDateAlternateKey],-1,MONTH))

I am not able to see the results of the past month, what should I do?

But when I choose the month slicer it works correctly.

@amitchandak 

[V-lianl-msft]

Hi @Nimai123 ,

Yes, this is related to the feature of measure, which is calculated according to the current context.

When you select slicer, it means that the context changes so that the measure you created will take effect.

Or you can recreate the measure, but you need to define your own filter conditions instead of using time intelligence functions.

You can refer to this thread:https://community.powerbi.com/t5/Desktop/calculate-the-total-sales-of-last-3-months-vs-current-month... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Nimai123 , Is this date column [FullDateAlternateKey]

and the table is marked as Date?

[Nimai123]

Yes,

And the table is also marked as a date.

@amitchandak 

[amitchandak · Accepted solution]

@Nimai123 , Try like

 last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

[parry2k]

@Nimai123 of course with current visual it doesn't know which month to look at and that's why it is not working and when you select a month value, it works.

Ask a question to yourself what you expect the result to be when a month is not select? How you want it to behave?