Error msg " The MAX function only accepts a column reference as an argument. "

[Paulyeo11]

Hi All

I get below expression from Amit :-

_Roll 12_2_ = CALCULATE(sum(SALES[sales]),DATESINPERIOD('Date'[Date],max(dateadd(SALES[date],-12,month)),-12,MONTH))

I get error msg :-

https://www.dropbox.com/s/u89uvu3lvn5mhpp/Rolling%20month%20for%20compute%20sales%20changes_.pbix?dl...

Above link is my PBI file

Paul

[amitchandak · Accepted solution]

@Paulyeo11 , try like

Last 12 before 12  = CALCULATE(SUM(Sales[Net Sales]), DATESINPERIOD('Date'[Date], maxx('Date', DATEADD('Date'[Date],-12,MONTH)),-12, MONTH))

[saibhav]

Hi Amit,

This was my problem too but the error was gone when I used MAXX instead of MAX. But it is showing just blank rows without data. 

I have used Rolling 3 for Previous year = CALCULATE([Volume],DATESINPERIOD('Date'[Date],maxx(dateadd('Date'[Date],-12,month)),-3,MONTH). Could you please help me in solving this?

Also, when I tried for Rolling 3 for Current year = CALCULATE([Volume],DATESINPERIOD('Date'[Date],max('Date'[Date]),-3,MONTH)), it worked but its not working for same months previous year.