topic Re: Get the data for previous of MAX month in DAX Commands and Tips

Get the data for previous of MAX month

Velvetine27 — Thu, 22 Jun 2023 08:16:52 GMT

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 !

Re: Get the data for previous of MAX month

devanshi — Thu, 22 Jun 2023 08:50:19 GMT

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

Re: Get the data for previous of MAX month

Velvetine27 — Fri, 23 Jun 2023 01:42:26 GMT

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."

Re: Get the data for previous of MAX month

devanshi — Fri, 23 Jun 2023 04:21:01 GMT

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

Re: Get the data for previous of MAX month

v-zhangti — Mon, 26 Jun 2023 05:54:25 GMT

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.