Get the data for previous of MAX month

[Velvetine27]

Hi,

I'm looking for ways to get data for PREVIOUSMONTH if we select multiple months. I just need the data for the previous month of the max selected date. If we select Jan till June, i want the sales data for May, which is the same if I select June only.
I've tried CALCULATE([SalesSum],FILTER(CalendarTable, DATEADD(CalendarTable[Date], -1,MONTH))) but it doesn't work. Appreciate any help here.

Thanks !

[v-zhangti · Accepted solution]

Hi, @Velvetine27 

You can try the following methods. 

Sample data:

Measure = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Month]=MAX('Table'[Month])-1))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[devanshi]

MaxSelectedDate = MAX('Table'[Date])
PreviousMonthSales = CALCULATE( SUM('Table'[Sales]),
                                                            DATEADD('Table'[Date], -1, MONTH) = [MaxSelectedDate] )

[Velvetine27]

Hi, there's an error to this dax, "A function 'DATEADD' has been used in a True/False expression that is used as a table filter expression. This is not allowed." 

[devanshi]

TRY this once, 
MaxSelectedDate = MAX('Table'[Date])
PreviousMonthSales = CALCULATE( SUM('Table'[Sales]),
                                                           DATESINPERIOD('Table[Date],MaxSelectedDate, -1,Month))