The MAX function in DAX only accepts a column reference as an argument

[Anonymous]

Hi All,

I am new to DAX. Below is my code:

var maxdate = MAX((DATEADD(DimDate[Date], -1 , month)))

From research, DATEADD returns A table containing a single column of date values.

However, I get the following error when I try to save the measure "The MAX function only accepts a column reference as an argument."  What is the name of the column in the table return by DATEADD so I can reference it?

[Anonymous]

Thanks @amitchandak and @jdbuchanan71  for your help

[amitchandak]

The above solution or you can try

 maxx('DimDate',DATEDIFF('DimDate'[Date],-1,MONTH))

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

Instead of MAX try it with LASTDATE, should give you what you are looking for.

VAR maxdate = LASTDATE ( DATEADD ( DimDate[Date],-1, MONTH ) )